The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have three data table like the Pictre, first table is demand for Chassis and PCA, second is Chassis BOM (shows how many PCA in this Chassis), Third is PCA BOM for lower level component. Is there any possibility to link all data together and come out the Lower level component demand by year with DAX ?
@PeterWu Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |