Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Need to create a function to Categorize values

Is there any way to create a column which will display only two values i.e "ClientSide", "OurSide" based on Colum A(ticketid) and ColumnB(interactionValue.) -For Example: if ticketId(ColumnA) 573319...
  • Rfranca's avatar
    Rfranca
    8 years ago

    hi, Anonymous

     

    Please try and test using it. And please mark the right reply as answer if your issue has been resolved, otherwise, please feel free to ask if you have any other issue.

    Best Regards,
    Rfranca

zayan's avatar
zayan
Regular Visitor
8 years ago

To create a conditional column, select the Data view in Power BI Desktop from the left side of the report canvas.

 

Select the the table that you need to add a column.

 

From the Add column tab (top in the ribbon), select Conditional Column.

 

This will popup.

 

 

Add your conditions and rules, and giva acolumn name instead of custom.

 

Enjoy!

Rfranca's avatar
Rfranca
Icon for Resolver IV rankResolver IV
8 years ago

 

Hi, Anonymous

 

Please, share the link where I can download your data file to help with the solution.

 

Best Regards,
Rfranca