topic Re: Contains in DAX Commands and Tips

Contains

Jedahn — Fri, 10 Feb 2023 03:18:10 GMT

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

SamInogic — Fri, 10 Feb 2023 03:58:16 GMT

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 crm@inogic.com

Power Platform/Dynamics 365 CRM Tips and Tricks: http://www.inogic.com/blog/

wdx223_Daniel — Fri, 10 Feb 2023 04:10:16 GMT

NewColumn=SWITCH(TRUE(),Table[ColumnA] IN {"Apples","Orange"},"Fruits",Table[ColumnA] IN {"Spinach","Potato"},"Fruits","Herbs")

Jedahn — Fri, 10 Feb 2023 07:54:34 GMT

Thank you for the reply. What does the 'Sample' in formula means? Is it the Table name or column name?