Forum Discussion
Date Table Relationship to Multiple Fact Tables
- 10 years ago
Hi There,
Please refer to this blog by Matt Allignton for solving your problem.
http://exceleratorbi.com.au/multiple-relationships-between-tables-in-dax/
Thanks & Regards,
Bhavesh
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!