The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a table with date and ticket id. I have a measure that shows created tickets. I also have date tables with slicer options like below
date(mm/dd/yyyy) | ticket |
6/21/2023 | 1 |
6/22/2023 | 2 |
6/27/2023 | 3 |
7/1/2023 | 4 |
7/2/2023 | 5 |
7/3/2023 | 6 |
7/7/2023 | 7 |
7/10/2023 | 8 |
7/12/2023 | 9 |
7/12/2023 | 10 |
Created tickets shows the right value as per slicer selection
however, I want to write a MoM and WoW change measure that shows the respective calculations. I tried something like this but its not working. Please let me know where I am going wrong.
July 2023 shows 4 as july had (7-3=4) increase in tickets.
Here's the sample pbix. Please help. test.pbix
User | Count |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |