Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following expression I would like to convert to Set Analysis and add a condition:
=(Sum([Budget])/Count([Budget]))
I need to add a condition for Year. The condition would be for current year which I have a variable for.
vFY is the name of the variable. So, Year=vFY
How can I convert this to Set Analysis and add this condition?
=(Sum({$<Year={'$(=$(vFY))'}>}[Budget])/Count([Budget]))
=(Sum({$<Year={'$(=$(vFY))'}>}[Budget])/Count([Budget]))