Percent Change Help

[eburg]

Hi- looking for help on how to calculate a simple year over year percent change. The first table shows the totals for each period in three fiscal years. Table two uses a measure to try and calculate % change. That measure is inserted below for reference. Obviously it's not working right as the percentages are way off. 

So for example the % change in the most recent period 9 would be 7.99% (9,242 vs 8,558 last year). and it's calculating at 20.2% percent. Any help with this measure or a different solution is greatly appreciated. Thanks.  

[Anonymous]

Hi @eburg ,

You are using ALL('Fiscal Calendar'). In my opinion, that will ignore the [Fiscal Period] filter.

You could try using ALLSELECTED() instead.

Or add another condition: [Fiscal Period] = selectedvalue([Fiscal Period]) in the filter.

If it still doesn't work, please share the pbix so that we could test the formula.

Best Regards,

Jay

[eburg]

My question on that example is I'm clear on why that additional table is needed. 

[ribisht17]

I did not have any problem with your Calculation, if you want I can share my PBIX ...

Total Sales LY =

VAR LY = SELECTEDVALUE(Orders[Year of Order Date],1)-1

VAR PY_AMT=

CALCULATE(sum(Orders[Profit]),

Orders[Year of Order Date]=LY

)

VAR RESULT=(SUM(Orders[Profit])-PY_AMT)/PY_AMT

RETURN RESULT

Regards,

Ritesh

[ribisht17]

@eburg 

Please check this example Solved: Calculating Percent Change - Microsoft Power BI Community

Regards,

Ritesh