Forum Discussion
Jonjon_99
Helper I
Helper IPOWER BI DAX IF STATEMENT
hi, i would like to create new column/DAX formula that will return my Product to "Others". this is the sample if the product = Montana, Paseo, Velo and VTT it will be tag as Others TIA! joh...
then it’s better for you to create a table with the names of the products in an Excel file and upload it to power bi
and then you can update the list at any time
----Measure = IF(MAX('yourtabl[product]) in VALUES('tablePro[Product]), "Others", MAX('yourtabl[product]))
Jonjon_99Helper I
Helper Ithanks for this Ahmedx , what if my product ID is more than 100 lines that i need to tag as "Others", what is the best measure to use? 🙂
Ahmedx
Super User
Super Userthen it’s better for you to create a table with the names of the products in an Excel file and upload it to power bi
and then you can update the list at any time
----
Measure = IF(MAX('yourtabl[product]) in VALUES('tablePro[Product]), "Others", MAX('yourtabl[product]))
- Jonjon_99
will check it. thanks!