Date Dim and Fact Tables

[LaxPBI]

Hi, I am a newbie to the group and PBI as well. From Matt's post , it is clear to use multiple look up instances of calendar date for multiple Date fields in 1 Fact Table and that is quite helpful. The issue in my case is a bit extended, where in my model there are multiple fact tables referencing Date tables and they are some how linked through other dimensions. So the question is " If there are multiple fact tables each with atleast 3 - 4 Date Fields , how to establish Date Dim relationships?". Understand , for date fields with in a fact, I can use multiple DAte Dim look up instances, but for multiple facts with multiple Date FIelds and the facts are connected through other Dimensions, what is the best way to establish Date Dim relationships. Thanks in advance!

[v-yuezhe-msft · Accepted solution]

Hi @LaxPBI,

All date fields in each Fact tables can be linked to your Date dimension table, just note that only one relationship can be active between a Fact table and Date table. For those date fields that have inactive relationship with date field in Date table, you can create measures per date action using USERELATIONSHIP function.

Thanks,
Lydia Zhang