Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |