Your question is SQL for Date-Based Selection and Power BI Modeling. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Explain how you would write SQL to return today’s rows when there is no explicit date column, and then describe how you would model the data in Power BI and write DAX queries.