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