Forum Discussion
DAX Direct Query - if text contains
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
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
Anonymous , I'm struggling with this too - did you find a good work-around?
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
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.