Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Spurgeon74
Frequent Visitor

Multiple Fact Tables one Calendar/Time Table

Ich möchte zwei Faktentabellen mit jeder Menge Messwerten mit einer Kalender und Zeit Tabelle verbinden. Wie sind hier die Beziehungen zu setzen? Kalender 1:* Fakten funktioniert nur bei der Verbindung zu einer Faktentabelle.

 

I want to connect two fact tables with lots of measured values ​​to a calendar and time table. How should the relationships be set here? Calendar/Time-Tble 1:* to Fact-Table only works when connected to only one fact table.

1 REPLY 1
vanessafvg
Super User
Super User

it depends on what you doing, how are you trying to use this.  essentially the calendar table in the middle of all the facts, you need to use the dates in calendar, when you say it only works, against one fact, what does that mean, please give a detailed explanation of the error and what you are expecting to see.  please also screenshot your relationship view so we can seee the relationships set up.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors