I'm creating reports by connecting to DWH in direcy query mode: select tables from DWH, create relations between the tables and so on...
I've noticed I cannot use DAX function "DateDiff" in new column.
Why is that?
Go to Solution.
Some DAX functions are not compatible with DirectQuery. See this article:
Proud to be a Super User!
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.