Forum Discussion
Anonymous
4 years agoNot applicable
How do I calculate difference between group rows in the same column - Power BI
- Anonymous4 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]