Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Matrix table subtract value to the left

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 

Need Help
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    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

1 Reply

  • MohammadLoran25's avatar
    MohammadLoran25
    Solution Sage
    3 years ago

    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