diffrence between 2 rows

Question

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.&nbsp;i created below measure which gives 2 years value while selecting only one year in the slicer.YearSlicerMeasure = var Yearselection = SELECTEDVALUE ('Date'[year])returnif( &nbsp; &nbsp; &nbsp;(max(vw_CLG_vwMLSFlashAllData_PowerPivot_FACTS[year]) &lt;= yearselection&amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&nbsp;max(vw_CLG_vwMLSFlashAllData_PowerPivot_FACTS[year]) &gt;= yearselection - 1) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;,1,0)

jihwan_kim · Accepted Answer

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.
&nbsp;

&nbsp;
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
    )

Forum Discussion

diffrence between 2 rows

2 Replies

Related content

calculate the diffrence

remove duplicate value within a row

Matrix Row Conditional Formatting

Where is the Multi-row card

Issue with Formulas - When Multiple Rows Similar Rows Exist