Forum Discussion

IliaS's avatar
IliaS
Regular Visitor
3 years ago
Solved

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?

1 Reply