Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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