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.
Solved! Go to Solution.
@Microbz , If plan_code and product_code have the same values. You need to create a new table using plan code and product code join with both tables and use it
new table
new dim = distinct(union(distinct(plan[plan_code]),distinct(dashboard[product_code])))
Thanks @amitchandak , I was thinking (hoping?) to maintain as two independent tables but in the end merging was easiest. Cheers!
@Microbz , If plan_code and product_code have the same values. You need to create a new table using plan code and product code join with both tables and use it
new table
new dim = distinct(union(distinct(plan[plan_code]),distinct(dashboard[product_code])))
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |