Forum Discussion

eburg's avatar
eburg
Frequent Visitor
4 years ago

Percent Change Help

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.  

 

Need Help

4 Replies

  • eburg's avatar
    eburg
    Frequent Visitor
    4 years ago

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

    • ribisht17's avatar
      ribisht17
      Super User
      4 years ago

      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
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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