Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
3 years ago

How to show difference in value

Hi, 

I have a line a clustred column chart with the x-axis showing a text output for the financial year (i.e 18/19, 19/20, 20/21 etc). 
I have the values below

FYValue
18/191.02
19/201.12
20/211.08

 

What I would then like to see as a secondary line would be the difference Year on Year. So my line would show

FYValueDiff
18/191.020.00
19/201.120.10
20/211.08

-0.04

 

Is there anyway of doing this within the chart automatically, or is there a calculation required and if so, what would it be please? The problem I think I have is that the 'FY' outputs are a text so can't use a MIN or MAX function. 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Try creating a calculated column in the "data" pane on the left hand side. You should get to your table and click "new column".

     

    = CALCULATE(SUM('Table'[Value]), SAMEPERIODLASTYEAR('Table'[Value]))

     

    Remember to replace 'Table'[Value] with whatever your table/column name is 🙂 Let me know!