Forum Discussion
Need help to create below DAX command
Community Championrubulsahu 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
- Greg_Deckler
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.
