Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculated column using SWITCH fucntion

Hi Experts , I am new to Power BI . My requirement is I need to populate  calculated column as Group from the existing column Item  for example  Item                       Group Shirt            ...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Hi Anonymous ,

    You may add a calculated column to your table with the following DAX:

    Group = 
SWITCH(TRUE(),
    'Table'[Item] = "Shirt", "Cloth",
    'Table'[Item] = "Pants", "Cloth",
    'Table'[Item] = "Laptop", "Electronic Device",
    'Table'[Item] = "Mobile", "Electronic Device",
    "Other")

    Is this what you are looking for?

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Hi Anonymous ,

You may add a calculated column to your table with the following DAX:

Group = 
SWITCH(TRUE(),
    'Table'[Item] = "Shirt", "Cloth",
    'Table'[Item] = "Pants", "Cloth",
    'Table'[Item] = "Laptop", "Electronic Device",
    'Table'[Item] = "Mobile", "Electronic Device",
    "Other")

Is this what you are looking for?

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

az38's avatar
az38
Community Champion
6 years ago

Anonymous JarroVGIT 

in case of simple comparision with the only column it should be easier to use statement like

Group = 
SWITCH('Table'[Item],
    "Shirt", "Cloth",
    "Pants", "Cloth",
    "Laptop", "Electronic Device",
    "Mobile", "Electronic Device",
    "Other")

 

do not hesitate to give a kudo to useful posts and mark solutions as solution