difference between two values in same column

Question

Year&nbsp; &nbsp; T otal Sales&nbsp; &nbsp; &nbsp; &nbsp;Difference in Sales from Last Year (should be result)2014&nbsp; &nbsp; 02015&nbsp; &nbsp;2.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.52016&nbsp; &nbsp;4.5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22017&nbsp; &nbsp;9&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4.52018&nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-92019&nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;How do you write dax for it?&nbsp;&nbsp;&nbsp;

v-piga-msft · Accepted Answer

Hi jiglow3501，
&nbsp;
Please create the calculated column with the formula below.
&nbsp;
Column =VAR temp =&nbsp;&nbsp;&nbsp; CALCULATE (&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MAX ( 'table'[Total Sales] ),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FILTER ( 'table', 'table'[Year] = EARLIER ( 'table'[Year] ) - 1 )&nbsp;&nbsp;&nbsp; )RETURN&nbsp;&nbsp;&nbsp; IF ( 'Table'[Total sales] - temp = 0, BLANK (), 'Table'[Total sales] - temp )

Then you will get the output below.
&nbsp;
&nbsp;
&nbsp;
&nbsp;
Best Regards,
Cherry

Forum Discussion

difference between two values in same column

2 Replies

Related content

Date Different return wrong value

Difference Value

Different schema into different destination

Difference between two table values with different dates

Differing values