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.
I have a list that has ticket numbers that could be repeating so I'm looking to do a data transform and group by the File_Date and then do a distinct count of rows but on the ticker number column, but when I try to select column, it is greyed out. Does anyone have any other work arounds?
Hi @jcastr02
An easy way to do that is to delet other columns befor group by and just keep File_Date and ticker number columns.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Thanks @VahidDM I'd eventually need the category column, because I'd need to group by that too. Any other thoughts?
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |