Forum Discussion
SWITCH with SAMEPERIODLASTYEAR does not work well
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
Community ChampionIliaS 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