Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Community Champion
Community Champion

Time Intelligence and Date Tables with numerous dates in tables

 of all, Ive juse done a course where it says time intelligence will only work on a Date table because of contiguous dates. Ive been using time intelligence on dates without a date table. Am I doing it wrong YEARTODATE etc etc ?


Also, if you use a date table, what if you have lots of dates in your tables. Orderdate, ModifiedDate etc etc and you need to connect every date up to your date table. I dont want multiple date tables so how would this work.


Another gripe, people say that having a date table is best but It feels wrong to me to have to go to the date table when you just want to work with say OrderDate from your Orders table. Is having a date table better than using the date time hierarchy under all the dates?

Solution Sage
Solution Sage

Hi @DebbieE


that is right, time intelligence requires a contiguous range of dates. It is considered a best practice to have a date table and it is actually a cornerstone of dimensional modeling. 

You do not need to create multiple date tables in your case, you can create inactive relationships 



Did I answer your question correctly? Mark my answer as a solution!

Proud to be a Datanaut!  

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors