topic Re: Need help to create below DAX command in DAX Commands and Tips

Need help to create below DAX command

rubulsahu — Tue, 30 Jan 2024 19:12:28 GMT

HI All,

I am very few to PowerBi and still catching up with its various commands. I have a complex requirement from business whereI have to calculate a new column using the formula defined in the image. First I have to filter on status and then based on values calculate the Assessmrt outcome value. Its very tricky for me and hoping someone could guide me in the right direction.

Re: Need help to create below DAX command

Greg_Deckler — Tue, 30 Jan 2024 19:40:29 GMT

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] )

Re: Need help to create below DAX command

rubulsahu — Tue, 30 Jan 2024 19:53:01 GMT

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

Re: Need help to create below DAX command

Greg_Deckler — Tue, 30 Jan 2024 20:07:56 GMT

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" )

Re: Need help to create below DAX command

rubulsahu — Tue, 30 Jan 2024 20:06:11 GMT

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.

Re: Need help to create below DAX command

Greg_Deckler — Tue, 30 Jan 2024 20:09:26 GMT

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.