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 why your month table has relationship 1:1, isn't it suppose to be 1:*, 1 one on Month side
Hi friedn!
Actually, this is the only relationship that is working for all tables. The 1-to-1 make sense for Month, as all the ables have 12 lines (one for each month). The other ones (Companies and Operation) I can't create a relationship with the other tables.