Forum Discussion
Many-to-Many Connection
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
Here the file,
You can see for example that DepartmentSale1 Sold 252 units in 01/2019 and 4 units at 02/2019, and i want to show each sales and goals speratly (using pivot columns)
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/823601Many Thanks!