topic Re: SWITCH with Multiple Columns in DAX Commands and Tips

SWITCH with Multiple Columns

TanyaT — Sun, 16 Oct 2022 03:20:18 GMT

Hello,

I would like for a column to return a value depending on the data present in two seperate columns. Here is my attempt to edit code I found online. I get an error. Any ideas?

Formal Status of Prob Tchrs = (DAX(Switch (True),

[P Calc] = 100 && [# of Formals] >= 1, "DONE",

[P Calc] = 100 && [# of Formals] = 0, "NEEDED",

[P Calc] = 200 && [# of Formals] >= 1, "DONE",

[P Calc] = 200 && [# of Formals] = 0, "NEEDED",)

Re: SWITCH with Multiple Columns

Jihwan_Kim — Sun, 16 Oct 2022 06:26:54 GMT

HI,

I am not sure how your datamodel looks like, but please try the below to create a new column.

Formal Status of Prob Tchrs = SWITCH ( TRUE (), [P Calc] = 100 && [# of Formals] >= 1, "DONE", [P Calc] = 100 && [# of Formals] = 0, "NEEDED", [P Calc] = 200 && [# of Formals] >= 1, "DONE", [P Calc] = 200 && [# of Formals] = 0, "NEEDED" )

Re: SWITCH with Multiple Columns

TanyaT — Sun, 16 Oct 2022 23:14:39 GMT

Jihwan_Kim...Hmmm...the Rename Column message I got was that model names must be non-empty. What does that mean?

Re: SWITCH with Multiple Columns

Jihwan_Kim — Mon, 17 Oct 2022 03:17:03 GMT

Hi,

Please share your sample pbix file's link, and then I can try to look into it.

Thanks.

Re: SWITCH with Multiple Columns

v-xiaotang — Tue, 01 Nov 2022 07:13:32 GMT

Hi TanyaT

Thanks for reaching out to us.

One of your column might not have any name. You can give the colum a name in the query editor and try again.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.