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

     

     

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
6 years ago

Hi,

 

You can use the "SWITCH" function in PowerBI. Declare variables like archivingvehicles = sum(archivingvehicles) and use them in switch function.

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad