Forum Discussion
Calculate Measure - Week on Week % with Count
I need calculate Week on week %. In single column i'm having data - "This Week", "Last week" and "Prev Week". I want to calculate WOW% . Here i need help in define CountA with Calculate
Hi 619SK ,
Here is a general approach to calculate the WoW percentage:
1.Create a measure for the current week's count:
ThisWeekCount = CALCULATE(COUNTA(Table[YourColumn]), Table[YourColumn] = "This Week")
2.Create a measure for the previous week's count:
LastWeekCount = CALCULATE(COUNTA(Table[YourColumn]), Table[YourColumn] = "Last week")
3.Create a measure for the WoW percentage:
WoWPercentage = DIVIDE([ThisWeekCount] - [LastWeekCount], [LastWeekCount])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.