Forum Discussion
If/ElseIf Statements from Tableau
Hello, I am still very new to PBI. Just had a question on how I should translate this to Dax? IF [# of Days Remaining]<0 THEN "Past Expiration Date" elseif [# of Days Remaining]>=0 and [# of D...
vicky_
Super User
Super UserI would suggest using the SWITCH() function; something like the following:
SWITCH(TRUE(),
[# of Days Remaining]<0, "Past Expiration Date",
[# of Days Remaining]>=0 && [# of Days Remaining]<=30,"1 Month",
// ... etc
)