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 think the simplest solution is to split the tables i.e. D1 in rows in 1 table, other D's in the other table. You can then join the tables using equipment number and your other conditions. This will only work if there is 1-Many relationship. You can use Power Query to do this.
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
25 | |
13 | |
13 | |
8 | |
8 |