Forum Discussion
Custom Column or Column Measure
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
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
2 Replies
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
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
