I need previous values- currentvalues same column

Question

hello everybody,&nbsp;i have tableamount&nbsp;&nbsp;&nbsp; cumilative&nbsp;&nbsp; diff2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 77&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;my table i have 2 column amount and cumulativebut i need diffrent previous values-current value&nbsp;anybody help me.&nbsp;&nbsp;thanksaruna

v-caliao-msft · Accepted Answer

Aruna_ln,
&nbsp;
In Power BI desktop data model,&nbsp; there are no orders for the records in your dataset. If you want to get previous value and calculated the different, you should have a order column. Please refer to the steps below to see the details.

Edit your query&gt;Add Column&gt;Index Column&gt;From 1
Cumilative columnCumilative = CALCULATE(SUM(Table1[Amount]),FILTER(Table1,Table1[Index]&lt;=EARLIER(Table1[Index])))
Diff = Table1[Amount]-LOOKUPVALUE(Table1[Amount],Table1[Index],Table1[Index]-1)

Regards,
Charlie Liao

Forum Discussion

I need previous values- currentvalues same column

1 Reply

Related content

Getting value for previous year based on value name and year slicer

Previous Day Value

Previous Row Value Dax

Previous Day Value

DAX getting previous value