Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
In my power bi dataset, I have an orders table with order id column. I want to show a report where in I compare the total orders per day of last week monday to this week monday, tuesday to tuesday so on for the entire week. I was able to achive the cumulative order count for week on week comparison with relative week i.e present week being 0 and last week being -1. But I want to further drill down and show day on day of last week vs current week. I am attaching a visual below with what I want to achive.
I used the dax
I made a calendar table.
Step 1: I made a calendar table.
Year hierarchy
Step 2: I made a relationship.
Step 3: I made some visuals.
Step 4: I did drilldown.
As my Power BI version is Japanese, days of week are Japanese.
I think when your Power BI version is English, days of week may be English.
Thank you, I was able to achive the visuals in the same way.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
59 | |
58 |
User | Count |
---|---|
157 | |
119 | |
104 | |
77 | |
69 |