Forum Discussion
Data Modeling Error
Hi, I am building a relationship among several tables and some auxiliar ones. The auxiliar tables are Month, Companies and Operation. Month has the name of the month and the correspondent month...
Anonymous very hard to tell what is going on. Can you share the pbix file? Remove sensitive information before sharing.
Anonymous Ah! I see you have to 1:1 relationship with month is causing this ambiguity. change that from many to one and it should work, even though fact tables have a single record for each month, force it to many to one with the month table and that should do it. T
Anonymous is there a relationship between companies and operation table? I cannot tell from the screenshot.
No, there isn't. Actually, these 2 tables I created inside Power Query. I wanted them to work just as auxiliar table for other to consulate to. There is no dependencies too: