Forum Discussion
aforapple_27
1 year agoFrequent Visitor
How can I assign Single value to a variable dynamically?
Amount for Previous Year = var prevYear = Calculate(SELECTEDVALUE('Raw data'[Year])-1) var prevYearFinal = prevYear return CALCULATE(SUM('Raw data'[Amount]), 'Raw data'[Year] IN {2024}) Abov...
hnguy71
1 year agoSuper User
Hi aforapple_27
Try this instead:
Amount for Previous Year =
var currYear = SELECTEDVALUE('Raw data'[Year])
var prevYear = currYear - 1
return
CALCULATE(SUM('Raw data'[Amount]), 'Raw data'[Year] = prevYear, ALL('Raw data'))
This should return you the amount for previous year.