Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
Please I Merged a Table and would like to know if there's a way to distribute the colors by car.
The intention is duplicate the car's line and a single color .
Is it possible? And How?
Solved! Go to Solution.
Hi @RNightscape,
We can use CROSSJOIN function to merge two tabels as you need.
Table = CROSSJOIN(car,color)
For more details, please check the pbix as attached.
Regards,
Frank
Hi @RNightscape,
We can use CROSSJOIN function to merge two tabels as you need.
Table = CROSSJOIN(car,color)
For more details, please check the pbix as attached.
Regards,
Frank
Thank you very much by your help! worked very well!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |