Custom Column or Column Measure

[cottrera]

Hi I am trying to a new column to a table that seaches the a column called ' Job Details' If the text in this table contains the word "Urgent" I would like y new column to say "Yes" otherwise leave blank.

The issue I have is that the report is using a Direct Query therefore I cannot add a custom column in power query.  Any suggestions

Direct Query Table
Ref	Job Details	*New* Column = Urgent
1	Fix Tab Urgent	Yes
2	Fix Stairs
3	Fix Tap
4	Fix Roof Urgent	Yes
5	Fix Gate
6	Fix Bath
7	Fix Shower
8	Fix Window
9	Fix Roof Urgent	Yes
10	Fix Window Urgent	Yes
11	Fix Shower Urgent	Yes
12	Fix Tab Urgent	Yes
13	Fix Bath

Richard

[lbendlin · Accepted solution]

That is actually an incorrect assumption.  You CAN have calculated columns in Direct Query as long as the computation is limited to the same row. Which is the case in your scenario.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#implications-of-using-directquery​

[cottrera]

Thank you for your response. I ready the document and you were right. I tried again and it did not work at first. It seemed that the applied steps were also affecting me adding a custom column. So I more the custom column step in front of all the other steps and it seemed to work.

RIchard