Forum Discussion
Continued ContributorWill making a data table via the CALENDAR() function slow down my queries or reports?
I have Free PBI Desktop v2.100.1182 (64 bit free version) on Windows 10.
I have these instructions for creating a date table. We do a lot of groupings by date, like by month or year-month.
If you dont have a Calendar Table you can easily create one with the following Table function. You are going to go to Modeling ribbon, then New Table.
The CALENDAR function works like this CALENDAR(Start Date,End Date)
Date = CALENDAR(DATE(2020,1,1),DATE(,2020,12,31)
Those fields don't look indexed in the date table. Will this slow down my queries and/or reports? Keep in mind some of my tables have 9 million records in them, each one with one or more date fields that I might need to set criteria on.
Thanks!
croberts21 In general, adding a date table with the proper relationships to other tables should greatly improve overall performance and is a best practice. Many people recommend create a date table in a source system like SQL or via Power Query instead of DAX but any method should improve performance overall.
1 Reply
- Greg_Deckler
Community Champion
croberts21 In general, adding a date table with the proper relationships to other tables should greatly improve overall performance and is a best practice. Many people recommend create a date table in a source system like SQL or via Power Query instead of DAX but any method should improve performance overall.