Getting last week data dynamically

[Sathvik123]

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. 

[v-rzhou-msft]

Hi @Sathvik123 ,

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.

[Sathvik123]

Hi @v-rzhou-msft ,

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]

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