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 2...
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

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