Forum Discussion

PeteD1302's avatar
PeteD1302
Icon for Helper I rankHelper 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
cklopper's avatar
cklopper
Frequent Visitor
5 years ago

Anonymous , I'm struggling with this too - did you find a good work-around?

PeteD1302's avatar
PeteD1302
Icon for Helper I rankHelper I
5 years ago

Hi, yes I did, dated 02-18-2019 08:28 PM as below

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/t...

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

 

Hopes this helps.