Forum Discussion
Drill Through
As I have two excel sheet. One is Credit-note Sheet and another one is Sales data sheet. I wanna link both the sheet through Drill- Through funtion, Since One of column party name is same in both of sheet but number of party name is diffrent.
How can I connect both of sheet using drill through option.
Plzz resolve this funtion as it is very crucial in nature.......
2 Replies
- amitchandak
Super User
Anonymous , you need to have common dimension tables like date, party, etc
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
miTutorialsPlease see the detailed tutorial on Drilldown.
This 'Drill Through' Feature in PowerBI will take your report to Next level | MI Tutorials - YouTube
