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