Last week data to display in power bi

[Anonymous]

Hi Folks, I have date column in my report based on date column when user selecting any date i want to display  last Monday date on  my report. Can you please help me on DAX. For example today is 23rd nov tuesday when user selecting on 23/11/2021 Tuesday i want to get date last monday(15/11/2021) same as for all. When ever user selecting any date date on middle of day i want to display always last monday.

[v-easonf-msft]

Hi, @Anonymous 

If your problem has been solved, you could accept the helpful answer as solution. 

It will help other community members easily find the solution when they get the similar issue.

If you still need help, please share more details.

Best Regards,
Community Support Team _ Eason

[PaulOlding · Accepted solution]

Hi @Anonymous 

Here's a measure to get you previous monday

Last Monday = 
VAR _SelectedDate = SELECTEDVALUE('Date'[Date]) 
VAR _Result = _SelectedDate - 7 - WEEKDAY(_SelectedDate, 3)
RETURN
    _Result