Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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.
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
@Sathvik123 The easiest way to do this would be to create a sequential column based on weeknum. Sequential - Microsoft Power BI Community
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |