Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am working on a problem which have multiple values(string) for a particular Month and I want to see all the values in the Matrix view instead of just First. How can I do that?
Current View:
Group | M1 | M2 | M3 | M4 |
A | Cricket | Football | BasketBall | |
B | BasketBall | BasketBall | ||
C | Football | Cricket |
Expected View
Group | M1 | M2 | M3 | M4 |
A | Cricket Football | Football | BasketBall Football | |
B | BasketBall | BasketBall | ||
C | Football Cricket | Cricket BasketBall |
I think CONCATENATEX () can be used but don't hav
Thanks
Yes, CONCATENATEX.
Please explain how you got from your sample data to the expected view. I don't understand the logic.