Couple of DAX questions around IF Statements

[Anonymous]

Hello,  Hoping you can help me with solving my two problems below. 

Problem One- Write these two statements in DAX- I copy and pasted what I use in Alteryx

2019 Outlet Status

If DateTimeYear([Outlet Max_Week Ending])=2018 then "Lost"
elseif DateTimeYear([Outlet Min_Week Ending])=2019 then "New"
elseif DateTimeYear([Outlet Min_Week Ending])= 2020 then "Other"
else "Active"
endif

2020 Outlet Status

If DateTimeYear([Outlet Max_Week Ending])=2019 Then "Lost"
elseif DateTimeYear([Outlet Min_Week Ending])=2020 then "New"
elseif DateTimeYear([Outlet Max_Week Ending])=2018 then "Other"
else "Active"
endif

Problem Two -Switch between the two variables above depending on the Slicer Selection

Selected Period Volume =

VAR PERSELECT =

SELECTEDVALUE ( 'Period Select (2)'[Period Selector])

RETURN

SWITCH (

PERSELECT,

"YTD",2020 Outlet Status,

"MTD", 2020 Outlet Status,

"2019", 2019 Outlet Status,

"Rolling 13 Weeks", 2020 Outlet Status,

"Pre-Covid W1-W9", 2020 Outlet Status,

"Prior 4wks", 2020 Outlet Status,

"Prior 13wks", 2020 Outlet Status,

"Prior 26wks", 2020 Outlet Status,

"Prior 52wks", 2020 Outlet Status)

Thanks for your help in advance. 

bret

[Greg_Deckler]

@Anonymous - Don't use nested IF ELSE statements, use SWITCH() or SWITCH(TRUE()...)

[Fowmy · Accepted solution]

@Anonymous 

You need to write the DAX version as follows for the first problem, I hope they are added as a calculated column.
2nd Problem is Measure I believe. You can adapt in the same way. I need more clarification on the second one, better if you could attach a sample PBIX file.

2019 Outlet Status = 

SWITCH( TRUE() , 
    DateTimeYear[Outlet Max_Week Ending] = 2018, "Lost",
    DateTimeYear[Outlet Min_Week Ending] = 2019,  "New",
    DateTimeYear[Outlet Min_Week Ending] = 2020, "Other",
    "Active"
)


2020 Outlet Status = 

SWITCH( TRUE(),

    DateTimeYear[Outlet Max_Week Ending] = 2019, "Lost",
    DateTimeYear[Outlet Min_Week Ending] = 2020, "New",
    DateTimeYear[Outlet Max_Week Ending] = 2018, "Other",
    "Active"
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn