Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Deepakkumarjha
New Member

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 2
miTutorials
Super User
Super User

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.