Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
Recently I've found certain bug in PowerBI Desktop. Firstly I'm getting data from SQL Database via DirectQuery. The table has date value (e.g CreateDate ). Secondly, I have that DAX table that serves as Calendar. The thing is: I can't make a many-to-one relationship between the table from database and DAX table by date. I've tried creating calendar using M but that didnt work aswell.
On the other hand, using Import (instead of DirectQuery) I am able to make such a relationship using both DAX and M as my Calendar.
DAX formula for creating Calendar table:
Calendar = CALENDAR(min('Table1'[CreateDate]),TODAY())
Any ideas? Any help would be much appreciated.
Michal
This is a limitation of direct query:
Calculated tables are not supported: The ability to define a calculated table using a DAX expression is not supported in DirectQuery mode.
Please see: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
I am using Composite Mode which , theoretically should be capable of doing both DirectQuery and Calculated Tables. Am I wrong?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |