Forum Discussion
Post PartisanDirect Query
Yes, you can. In DirectQuery you won't see the Data view, but you can still right-click the table in the Data pane and pick New column.
The catch is that it has to be a row-level expression that can be pushed down to the source, meaning it can only use other columns from the same row of that table, no aggregations. Functions that can't fold just won't show up in autocomplete.
Docs: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Hope this helps!
https://www.linkedin.com/in/richard-ampie-218a07247/
Super UserHello mp390988,
Yes, you can create calculated columns on DirectQuery tables in Power BI, but with certain restrictions.
The important limitation is that functions requiring complex filter context or table iteration, such as CALCULATE() and SUMX(), aren't supported in these calculated columns.
For more complex calculations, I'd recommend creating the column directly in SQL or using a Power Query transformation that supports query folding. Microsoft's DirectQuery documentation explains the restrictions.