Matrix table subtract value to the left

[Anonymous]

Hi Experts

How would yo do the following on a matrix table in Power BI (the expected end result is in the sample excel file)

I want to be abloe to subtract the value to the left start point 2nd column in - Hence (2949 - 2083) =-866 and so on 

Data

Sample data with expected end result.

Link: https://www.dropbox.com/scl/fi/x6sm7wt07b94v7umt727v/Book1.xlsx?dl=0&rlkey=50w1tpy8qcp8zyd8zpl0vpusg 

[MohammadLoran25 · Accepted solution]

Hi @Anonymous ,

I do not know exactly your fields (PDate and Date).

But what you need is sth like this:

[YourMeasure]
    - CALCULATE (
        [YourMeasure],
        FILTER (
            ALL ( 'DateTable' ),
            'DateTable'[Date]
                = MAX ( 'DateTable'[Date] ) - 1
        )
    )

If this answer solves your problem, give it a thumbs up and accept it as a solution so the others would find what they need easier.

Regards,

Loran