Getting last week data dynamically

[Anonymous]

Hello All,

I need to create a dax where I can show last week data from sunday to saturday.

I have data like below.

So whenever in this week I ran the report I need to show only last weeks data as highlited below. 

[Anonymous]

Hi @Anonymous ,

You can try "Relative date" feature in [Date] column in Filter field. Show items when the value is in the last 1 calendar week.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

I need to do this using dax only as I have other filters also based on slicer selection

liike If I select daily then yesterday

weekly then last week

monthly then last month 

[Greg_Deckler]

@Anonymous The easiest way to do this would be to create a sequential column based on weeknum. Sequential - Microsoft Power BI Community