Forum Discussion
Getting last week data dynamically
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 da...
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.
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