Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Best way to add a calendar table with data from sql

Hi all. First of all thank you for your help!  Let me explain to you my current situation: Source of the data: Database. Date fields: 2, so I'd like to have two calendar tables. Is there any cal...
Need Help
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Are you making your 2nd date table with DAX or M?  If M, do you have enable parallel loading enabled (turn off if so you are not pulling your data twice from the database)?  Also, is the date table from your source also related to your fact table (min to max)?  If so, you could use the min/max from the calendar table instead.

 

Pat

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Pat, thanks for your answer! About your points:

  • I'm using always a connection to the database to pull the calendar table. This calendar table is a generic one related with many fact tables by a numeric id.
  • As the two date fields from the fact table would have different min&max I'm pulling my data twice. Is it necessary?
  • The calendar table from the database is related with the fact table but the calendar table has all the dates (until 2099 If I recall well) and I just want the ones within a range

 

Does it help? Thanks in advance