I got stuck with a many-2-many relationship ...
I have three tables
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.
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 5 guests