Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Conditonal Column based on Calculated Columns

Hi,    I have a table, where I have created 3 calculated columns, that tell me if that ID appears in another table. Looks like this:    What I want to do is add another column that would ca...
Calculated columns
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    i missed an &

     

    Try this

     

     

    Calculated Column =
VAR a = 'Table'[archivingvehicles]
VAR b = 'Table'[deleting vehicles]
VAR c = 'Table'[invoicingvehicles]
RETURN
    SWITCH (
        TRUE (),
        a = 1
            && b = 0
            && c = 0, "A",
        a = 1
            && b = 1
            && c = 0, "A,D",
        a = 1
            && b = 1
            && c = 1, "A,D,I",
        a = 0
            && b = 1
            && c = 0, "D"
    )

     

     

    Regards,

    Harsh Nathani

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

 

Not sure why. I tried it. It is working.  make sure both places you have a &&    &&

 

 

 

Regards,

HN

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous 

 

I'm not sure why either. What I have done is changed the 1,0 to YES and NO as a Text type and it has worked. 

 

Thank you for all your help!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    The Column may have changed to Boolean or Text.

     

    Change it to Whole Number or Decimal and this formula will work.

     

    Regards,
    Harsh Nathani

    Appreciate with a Kudos!! (Click the Thumbs Up Button)
    Did I answer your question? Mark my post as a solution!