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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.