Forum Discussion
Calculate % Change
Hi there,
Struggling with a % change calculation which seems so simple but doesnt return anything.
The calculation is the current Year/Period - Previous Year/Period / Previous Year/Period
Have created measures for the Period/Years i want to compare and summed the total salary bill. However, the calculation doesnt seem to return anything and have tried several different ways of writing the calculation. Any assistance would be greatly appreciated.
Thanks
Hi Anonymous
Can you explain why you are using CALCULATE()?
Have you tried the measure without it?
Hi Anonymous
Is there any way that your 3 table visuals (FY21-P10, FY22-P10, FY23-P10) each have a filter limiting rows to one particular period?
This could cause the problem since the previous year's rows would be outside of the period.
Does this make any sense? I'm running out of options.
8 Replies
grantsambornSolution Sage
Hi Anonymous
Can you explain why you are using CALCULATE()?
Have you tried the measure without it?
Hi grantsamborn
Not solved!
Have tried using calculate(), divide(), without any commands but nothing has worked
Hi grantsamborn,
Just to be clear, this hasnt been resolved and before i repost as i cannot seem to remove the marker for this being solved, are you able to advise why the calculation isnt working?
- grantsamborn
Hi Anonymous
Sorry about that. I was wondering why it was marked as a solution while you said it didn't work.
Is there any way you can produce sample data with which you can replicate the problem?
Can you show what [P10 F22] and [P10 F23] measures look like?
At this point, I'm just taking shots in the dark.
Grant