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

[Anonymous]

[Anonymous · Accepted solution]

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]

[Jackbaz99]

difference = CALCULATE([NewLeaseCount], SAMEPERIODLASTYEAR('Date Table'[Date]))

Should help you - use your date table where mine is

[Jackbaz99]

*Note this is for year on year only