Forum Discussion
Need help to create below DAX command
rubulsahu Use a SWITCH(TRUE()...) statement like:
Column =
SWITCH(TRUE(),
[Global Assessment Outcome] <> BLANK(), [Global Assessment Outcome],
[Triage Outcome] <> "Select One", [Triage Outcome],
[PreImpAss Outcome] = "SELECT ONE", "NA",
[PreImpAss Outcome]
)
Hi Greg_Deckler Thankyou so much for the prompt response. But I have to first filter Status Value(col 1) . How I can include If with Switch?
When Status is cancelled then Cancelled
When Status in(
Administrative Update
Global Cross-functional Impact Assessment in Progress
Global Implementation Ongoing
Local Implementation Only (no Global Impact)
Local Implementation (Global Implementation Complete)
Completed PV Policy Activities
) then
Switch
rubulsahu Should be simple:
Column = SWITCH(TRUE(), [Status] = "Cancelled", "Cancelled", [Global Assessment Outcome] <> BLANK(), [Global Assessment Outcome], [Triage Outcome] <> "Select One", [Triage Outcome], [PreImpAss Outcome] = "SELECT ONE", "NA", [PreImpAss Outcome] )This assumes that all other values for Status should go through the rest of the evaluation process. If that is not the case then you could do this:
SWITCH(TRUE(), [Status] = "Cancelled" || [Status] = "Administrative Update" || [Status] = "Global Cross-functional Impact Assessment in Progress", // add more or statements as necessary SWITCH(TRUE(), [Status] = "Cancelled", "Cancelled", [Global Assessment Outcome] <> BLANK(), [Global Assessment Outcome], [Triage Outcome] <> "Select One", [Triage Outcome], [PreImpAss Outcome] = "SELECT ONE", "NA", [PreImpAss Outcome] ), "Something else" )​HI Greg_Deckler
Thereare other values in the status apart from Cancelled and listed below
(
Administrative Update
Global Cross-functional Impact Assessment in Progress
Global Implementation Ongoing
Local Implementation Only (no Global Impact)
Local Implementation (Global Implementation Complete)
Completed PV Policy Activities)
I want to select only these for switch statement.
rubulsahu See edited post above. Again, if there are no other status other than those listed in the image then you can use the first version. Otherwise, you would use the revised version.