topic Formula Not working - Changing measure based on slicer year in DAX Commands and Tips

Formula Not working - Changing measure based on slicer year

olivere91 — Thu, 22 Jun 2023 20:57:08 GMT

I have a formula that should change the measure if the year is not 2023. It returns the measure Margin $ if the year is before 2022, that's great, but if the year is 2023 then Margin $ new should be returned and it's not.

GM Dollars =

SUMX (

VALUES ( Item_Sales_Profit[Customer No.] ),

SWITCH (

TRUE (),

Item_Sales_Profit[Customer No.] = "cus"

&& YEAR(SELECTEDVALUE(Dates[Year])) >= 2023,

[Margin $ New],

Item_Sales_Profit[Customer No.] = "cus"

&& YEAR(SELECTEDVALUE(Dates[Year])) < 2023,

[Margin $],

[GM $]

)

Re: Formula Not working - Changing measure based on slicer year

some_bih — Fri, 23 Jun 2023 06:14:40 GMT

Hi olivere91 did you try to "switch" conditions in your measure, like change places of "year" part filter? Switch restrict some results.

Check link https://dax.guide/switch/ (last 2 examples)

Hope this help

GM Dollars =

SUMX (

VALUES ( Item_Sales_Profit[Customer No.] ),

SWITCH (

TRUE (),

Item_Sales_Profit[Customer No.] = "cus"

&& YEAR(SELECTEDVALUE(Dates[Year])) < 2023,

[Margin $],

Item_Sales_Profit[Customer No.] = "cus"

&& YEAR(SELECTEDVALUE(Dates[Year])) >= 2023,

[Margin $ New],

[GM $]

)