Many to Many Relationship

Anything related to PowerPivot and DAX Formuale
Franz
Posts: 2
Joined: Mon Feb 25, 2019 5:31 am

Many to Many Relationship

Postby Franz » Fri Mar 15, 2019 8:18 am

Dear community

I got stuck with a many-2-many relationship ...

I have three tables
tables.png
tables.png (13.57 KiB) Viewed 78 times


I googled and got an idea how to link my p&l table to my functions table - in general.
However, I don't just want to filter my p&l by functions I also want to allocate the values in the p&l to the functions i.e. multiply the two values. And that's were I got stuck.

And as an add-on: whenever I tried so solve the issue, I got the yellow warning message "relationships between tables may be needed". How do I need to set it properly to avoid this warning?

Any help is highly appreciated.

Regards
Franz
Attachments
Many2Many.xlsx
(225.74 KiB) Downloaded 3 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 5 guests