Forum Discussion
Solved
Microsoft BI Desktop DAX Formula
Hi, I am hoping somebody can provide some direction on a problem I am having. I am trying to create a report in BI Desktop. I've loaded the data that has multiple columns. Specifically - her...
Hi amirzoyan ,
Would you please follow the steps in the link :https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning
For more details, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/ESGiM9r4KfxLuiK-6UwsD4wBkmPn0--aDHHaWBvpfxs_Kg?e=0rs4dh
Best Regards,
Dedmon Dai
amitchandak
Super User
Super UserYou can create a new column
switch(true(),
search("Consumables",[Product Hierarchy 2],,0)>0 ,"Consumables (1&2)",
search("Hardware",[Product Hierarchy 2],,0)>0 ,"Hardware (1&2)",
"Others"
)
Or refer :https://radacad.com/grouping-and-binning-step-towards-better-data-visualization