Forum Discussion
Contains
Hello everyone,
What DAX formula i can use the same with the one I'm using in Tableau calculations. Please see example for my tableau calculation:
IF CONTAINS([ColumnsA], "Apples")
OR CONTAINS([Column A], "Orange")
THEN "Fruits"
ELSEIF
IF CONTAINS([ColumnsA], "Spinach")
OR CONTAINS([Column A], "Potato")
THEN "Vegetables"
ELSE "Herbs" END
Your help would be appreciated. Thank you
Hi Jedahn,
You can use below DAX expression to create a column in a table:
Column = If(CONTAINSSTRING('Sample'[Column A], "Apples") || CONTAINSSTRING('Sample'[Column A], "Orange") , "Fruits",
IF(CONTAINSSTRING('Sample'[Column A], "Spinach") || CONTAINSSTRING('Sample'[Column A], "Potato") ,"Vegetables","Herbs"))
Please refer to the below screenshot,
If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.
Thanks!Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Hi Jedahn,
Yes, "Sample" is a Table name in the Power BI report. Please find reference screenshot of the Power Query for Table :Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
4 Replies
Hi Jedahn,
You can use below DAX expression to create a column in a table:
Column = If(CONTAINSSTRING('Sample'[Column A], "Apples") || CONTAINSSTRING('Sample'[Column A], "Orange") , "Fruits",
IF(CONTAINSSTRING('Sample'[Column A], "Spinach") || CONTAINSSTRING('Sample'[Column A], "Potato") ,"Vegetables","Herbs"))
Please refer to the below screenshot,
If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.
Thanks!Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
Thank you for the reply. What does the 'Sample' in formula means? Is it the Table name or column name?
Hi Jedahn,
Yes, "Sample" is a Table name in the Power BI report. Please find reference screenshot of the Power Query for Table :Thanks!
Inogic Professional Service Division
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at [email protected]
Service: http://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/
NewColumn=SWITCH(TRUE(),Table[ColumnA] IN {"Apples","Orange"},"Fruits",Table[ColumnA] IN {"Spinach","Potato"},"Fruits","Herbs")
