Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have data which is usually updated weekly but sometimes it would skip a few weeks.
I need a measure that I can use the compare a percentage measure from the current week to the last available week (not necessarily -7 days).
I have a measure that works to give me just the date output which is:
HI @Hayleysea
Add a weeknum column for date column, then just refer to this post:
If you still have the problem, please share some sample data and your expected output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Lin
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |