Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all
How to find the deparments that share the same customer.
I have this issue.
I have 2 Departments aka PROJTABLE.DIMENSION = 60 and 70
how many customers do they share aka PROJTABLE.CUSTACCOUNT
I have 2 tables
Customer table : CustTable where the accountnum is, that are linked to PROJTABLE.CUSTACCOUNT
And PROJTABLE where the dimensions are
Hi @JENS,
>>How to find the deparments that share the same customer.
Perhaps you can try use INTERSECT function to get the intersection result, I think it will be suitbale for your requirement.
Reference link:
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |