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 all,
i have following situation:
I could solve this in SQL with cross apply and for XML path command but looking for a way to do this now in DAX. I think "Distinct Client" and "Count PK" would be easy to implement with SUMMARIZE but how can i get a compilation of the contracts? In some cases i have over 250 same contracts and i need it just once in the column "Existing Contract".
Best Regards
Pikachu-Power
Solved! Go to Solution.
@Pikachu-Power , Create a measure
concatenatex(distinct(Table[Contract]), [Contract],"+" )
Great! Much easier than in SQL. Wouldnt have expected. Thanks!
@Pikachu-Power , Create a measure
concatenatex(distinct(Table[Contract]), [Contract],"+" )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
79 | |
64 | |
62 | |
57 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
66 |