Forum Discussion

PeteD1302's avatar
PeteD1302
Helper I
7 years ago
Solved

DAX Direct Query - if text contains

I have a direct query where I need to add a new column; looking for a part of the text sting and reporting specifed string. I have viewed a number of posts for IF and CONTAINS and none of the soluti...
Need Help
PeteD1302's avatar
PeteD1302
Helper I
7 years ago

Jimmy Tao, I made the suggested change.

I am still having issue with correct DAX command, which is correct or none.

e.g.

IF (Text.Contains('Table'[Name], "NEW") then NEW else "OLD

or IF ('Table'[Name], Text.Contains ("NEW"), then NEW else OLD

or IF (CONTAINSROW('Table'[Name], "NEW") then"NEW" else OLD

or  IF ('Table'[Name], CONTAINSROW ("NEW") then NEW else OLD

 

PeteD1302's avatar
PeteD1302
Helper I
7 years ago

I have managed to find a solution from a search for"Re: Conditional Columns or IF Conditions in Direct Query mode" from 04-30-2017. The link as below

https://community.powerbi.com/t5/Desktop/Conditional-Columns-or-IF-Conditions-in-Direct-Query-mode/td-p/165966

With the resulting direct query as follows;

IF(Table[Name]="NEW"),"NEW", "OLD

This is for a New Column and helps to identify what are new and old items from a very large SQL server source