Forum Discussion
Many-to-Many Connection
Hey, I'm trying to make a Power Pivot table that shows me a list of departments with its sales vs. goals. I'm using two DB's - MonthlyGoals and MonthlySales. Because there is many-to-many con...
Please find the file
https://www.dropbox.com/s/rvsg9nb7wjfg4y9/sample_v1.1.pbix?dl=0
Created a monthly table. And joined the tables on that. Please check the converted matrix, if that can help.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hey, Accidentally I highlighted the connection - it doesnt mean nothing. How can i share the file here? I alreday removed a sensitivie info.
You can share via SharePoint, dropbox etc