Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I'm trying to write a report that will tell us if vendors are set up in the proper companies. I'm playing with a matrix, but the matrix will not show the column if there is no data to support it. Here are the 3 tables I'm working with and an example:
Company table: main financial table listing all available companies
vendor table 1: vendor table with no company name (vendor master)
vendor table 2: each row has the vendor name and the company they are set up for. In this example, there would be two rows in that table (financial system company vendor master)
Any help or guidance is greatly appreciated.
Vendor | Company A | Company B | Company C |
Acme | Yes | No | Yes |
Solved! Go to Solution.
That worked great, Marcus! Thanks!
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |