Subtracting a cell value from a another cell (measure) in a single column

[rshaw1768]

Hello Guys,

I want to create a column/Measure which yields the difference between alternate columns.

Like the difference in Votes between Rank 1 & Rank 2 will show in Row 1 & So on.

The Last Row will be zero or same as no of votes for Rank 18.

If anyone has some idea regarding this, please share your views.

Thank You.

[Ashish_Mathur]

Hi,

If you want a measure, share the link from where i can download your PBI file.

[v-qiuyu-msft · Accepted solution]

Hi @rshaw1768,

You can create a calculated column below: 

Diff = IF('Table1'[Rank]=MAX('Table1'[Rank]),0,Table1[Votes]-LOOKUPVALUE('Table1'[Votes],'Table1'[Rank],'Table1'[Rank]+1))

Best Regards,
Qiuyun Yu