Forum Discussion
SWITCH function with result TEXT
Hello all, I have something pretty simple i guess, but i can not figure this out how with DAX. I am looking for a result "Yes"or "No" as text. On Time Correction Result Yes Yes Yes...
FrankAT
Community Champion
Community ChampionHi Anonymous ,
you can do it like this:
Result = SWITCH(TRUE(),
MIN('Tbl'[On Time]) = "Ja", "Ja",
MIN('Tbl'[On Time]) = " ", " ",
MIN('Tbl'[On Time]) = "Nee" && MIN('Tbl'[Correction]) = "Ja", "Ja"
)
With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)