Drill Through

[Deepakkumarjha]

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.......

[miTutorials]

Please see the detailed tutorial on Drilldown.

This 'Drill Through' Feature in PowerBI will take your report to Next level | MI Tutorials - YouTube

[amitchandak]

@Deepakkumarjha , 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-soluti...

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw