Forum Discussion

TanyaT's avatar
TanyaT
Regular Visitor
3 years ago
Solved

SWITCH with Multiple Columns

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

 

 

 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

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

     

4 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

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

     

    • TanyaT's avatar
      TanyaT
      Regular Visitor
      3 years ago

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

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        3 years ago

        Hi,

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

        Thanks.