Subtracting Columns

[BICrazy]

Hi there Power BI Community....  I need your help, please.

I need to create a measure that subtracts the preceding column from the next and displays the answers only (in bold red below).

Example
1st row:
May-19   14 - 6 = 8, 6 - 5 = 1, 5 - 4= 1, 4 - 4= 0, 4 - 4= 0 

2nd Row
Jun -19   158 - 123= 35, 123 - 115= 8, 115 - 101 = 14

and so forth for each row and column.

Here's a Matrix view of the data. 

[Fowmy · Accepted solution]

@BICrazy 

Here is your measure:

Measure = 

VAR CV = MAX(Table1[Value])
VAR D = SELECTEDVALUE(Table1[Day])+1
RETURN
CV-
CALCULATE(
    MAX(Table1[Value]),
    Table1[Day] = D,
    ALLSELECTED(Table1[Day])
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Fowmy · Accepted solution]

@BICrazy 

Here is your measure:

Measure = 

VAR CV = MAX(Table1[Value])
VAR D = SELECTEDVALUE(Table1[Day])+1
RETURN
CV-
CALCULATE(
    MAX(Table1[Value]),
    Table1[Day] = D,
    ALLSELECTED(Table1[Day])
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[BICrazy · Accepted solution]

Thanks Fowmy,

The measure worked like a charm. I just inserted the portion to accommodate the blanks on my data set.

Previous Index Policies = 
VAR CV = [Bank Submissions]
VAR D = SELECTEDVALUE('Ongoing & Unpaid Data Revised'[Index])+1
RETURN
CV-
CALCULATE(
    [Bank Submissions],
    'Ongoing & Unpaid Data Revised'[Index] = D && CV <> BLANK(),
    ALLSELECTED('Ongoing & Unpaid Data Revised'[Index]))