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.
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.