Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

diffrence between 2 rows

Hi, I want to subtract the value from the year 2022 - 2021, can someone help me for creating measure so i can put the diffrence value just below the 2021,2022 row.   i created below measure w...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.

     

     

    New Lease Count Measure: =
VAR _recenttyear =
    CALCULATE ( MAX ( Data[Year] ), ALL ( Data[Year] ) )
VAR _previousyear = _recenttyear - 1
VAR _diff =
    CALCULATE ( SUM ( Data[NewLeaseCount] ), Data[Year] = _recenttyear )
        - CALCULATE ( SUM ( Data[NewLeaseCount] ), Data[Year] = _previousyear )
RETURN
    SWITCH (
        TRUE (),
        ISINSCOPE ( Data[Year] ), SUM ( Data[NewLeaseCount] ),
        ISINSCOPE ( Data[Month] ), _diff
    )
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file whether it suits your requirement.

 

 

New Lease Count Measure: =
VAR _recenttyear =
    CALCULATE ( MAX ( Data[Year] ), ALL ( Data[Year] ) )
VAR _previousyear = _recenttyear - 1
VAR _diff =
    CALCULATE ( SUM ( Data[NewLeaseCount] ), Data[Year] = _recenttyear )
        - CALCULATE ( SUM ( Data[NewLeaseCount] ), Data[Year] = _previousyear )
RETURN
    SWITCH (
        TRUE (),
        ISINSCOPE ( Data[Year] ), SUM ( Data[NewLeaseCount] ),
        ISINSCOPE ( Data[Month] ), _diff
    )
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, Jihwan_Kim 
It works, Thank You for your support.