Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How do I calculate difference between group rows in the same column - Power BI

 
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thank you Jackbaz99 for assisting.

    However, below 3 Measures worked for me.

     

     

    Newleasecount_CY =
    var CurrentYear = SELECTEDVALUE('Date'[Year])
    return
    CALCULATE(SUM('View Name'[NewLeaseCount]),FILTER(ALL('View Name'),'View Name'[Year]=CurrentYear))


    Newleasecount_PY =
    var CurrentYear = SELECTEDVALUE('Date'[Year])
    return
    CALCULATE(SUM('View Name'[NewLeaseCount]),FILTER(ALL('View Name'),'View Name'[Year]=CurrentYear-1))


    Diff_NewLeaseCount = [Newleasecount_PY] -[Newleasecount_CY]