Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.......
Please see the detailed tutorial on Drilldown.
This 'Drill Through' Feature in PowerBI will take your report to Next level | MI Tutorials - YouTube
@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
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |