Calculated column using SWITCH fucntion

[Anonymous]

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                        Cloth

Pants                      Cloth 

Laptop                    Electronic Device 

Mobile                    Electronic Device

Kindly suggest .

Regards

Ganesh Jagdhane 

[JarroVGIT · Accepted solution]

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]

@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