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 need some help.
I have a column like that :
and if i use DISTINCTCOUNT 'Table'[Profile] i got 3 as answer
But i would like it to be case sensitive and to obtain 5 as answer. (a,A,b,B,C)
How do you do that?
Thanks.
Solved! Go to Solution.
Well, the bad news is that Dax doesn't distinguish between upper and lower case letters.
The good news is that power query does.
What you can do is a GROUP BY in power query and then COUNTROWS in the grouped table.
Well, the bad news is that Dax doesn't distinguish between upper and lower case letters.
The good news is that power query does.
What you can do is a GROUP BY in power query and then COUNTROWS in the grouped table.
Hello,
That's what i thought.
Guess i will rename it in power query since i need to do more than COUNTROWS.
I will open an other discussion for that.
Thanks
Have a nice day.
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 |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |