Forum Discussion
Hayleysea
Resolver II
6 years agoLast available week measure not returning correct value
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 w...
v-lili6-msft
Community Support
6 years agoHI 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