Forum Discussion

Jedahn's avatar
Jedahn
Frequent Visitor
3 years ago
Solved

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 CON...
  • SamInogic's avatar
    SamInogic
    3 years ago

    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/

  • SamInogic's avatar
    SamInogic
    3 years ago

    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/

SamInogic's avatar
SamInogic
Super User
3 years ago

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/

Jedahn's avatar
Jedahn
Frequent Visitor
3 years ago

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

  • SamInogic's avatar
    SamInogic
    Super User
    3 years ago

    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/