Forum Discussion
% Difference between Measures
Hi guys, im trying to calculate simple way difference between tow rates or even more but I dont find the proper way to do it. Here is the thing: Id like to calculate differences betw...
It doenst work
being honest I dont understand how something seems so easy such as "% differences between figures" finally is so complex to do.
Hey
First I would split the fiscal year field or create another one from that one with just the number (stored as a number).
Then I would create a measure as following (just a guide, adapt so it takes your fields and tables):
measure =
var fiscalyear = SELECTEDVALUE(FY_number)
var currentYear = CALCULATE(SUM('ratios y metricas'[importe neto]), FY_number = fiscalyear)
var previousYear = CALCULATE(SUM('ratios y metricas'[importe neto]), FY_number = (fiscalyear - 1))
var result = DIVIDE(currentYear, previousYear, BLANK())
return result