Forum Discussion
Solved
Adding a date range field
I'm very new to Power BI so am not familiar with all functionality... I'm trying to set up a report where I can filter all fields by an annual date range without depending on when transactions ha...
Hi JoshK,
The connection type is Import in your scenario. Here we cannot create calculated table. You can only model your data in your data source side. Please refer to the online document to check the limitations of Direct Query.
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
Regards,
Frank
Hi JoshK,
Please check the following steps.
1. Create a CALENDAR table.
Table = CALENDARAUTO()
2. Create relationship between calendar table and the fact table.
3. Create a table visual as below , please notice here we should enable the option "show items with no data".
For more details, please check the pbix as attached.
Regards,
Frank
Thanks for your reply.
This makes sense in principle but 'New Table' is greyed out and unavailable...