Forum Discussion
SWITCH with SAMEPERIODLASTYEAR does not work well
I am writing a DAX like this
VAR sv = SELECTEDVALUE(‘select type’[type])
VAR test = SWITCH(sv, “Off”, SUM(prod[abs_off]), “On”, SUM(prod[abs_onl]))
VAR previos_val = CALCULATE (
test,
SAMEPERIODLASTYEAR(‘Date’[Date]) )
RETURN DIVIDE (test, previos_val) * 100
in the result it always returns 100, although if I insert a value from switch results into calculate(), all works well. How to fix this issue?
IliaS Variables (VAR) are not dynamic or well, variable. Confusing yes. Variables are static once calculated so you can't recalculate them using CALCULATE. If you separate into 2 measures then yes. Also, I recommend avoiding TI functions. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008
1 Reply
- Greg_Deckler
Community Champion
IliaS Variables (VAR) are not dynamic or well, variable. Confusing yes. Variables are static once calculated so you can't recalculate them using CALCULATE. If you separate into 2 measures then yes. Also, I recommend avoiding TI functions. You may find this helpful - https://community.powerbi.com/t5/Community-Blog/To-bleep-With-Time-Intelligence/ba-p/1260000
Also, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008