Forum Discussion

Mkhubaib's avatar
Mkhubaib
Frequent Visitor
6 years ago
Solved

Merging same row data in column into one

So i am having a trouble here. Below mentioned is the sample data   Here in LineItemCategory column Luxury Pret and Luxe Pret are same. So for visulaization i want to merge both of these and ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Mkhubaib 

    Create a calculated column like

    Category = 
IF(Table[LineItemCategory] = "Luxe Pret", "Luxury Pret", Table[LineItemCategory])

    and use this new column for visual as a category 

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Mkhubaib 

Create a calculated column like

Category = 
IF(Table[LineItemCategory] = "Luxe Pret", "Luxury Pret", Table[LineItemCategory])

and use this new column for visual as a category