Forum Discussion
Solved
Use Distinct Count in Power Query Editor to Create a Calculated Column
Hi Gurus,
Is it possible for me to use Distinct Count to create a new calculated column in Power Query Editor instead of creating a calculated measure using DAX?
Thanks,
Paul
Hi polaris3028,
You can use Table.RowCount and Table.Distinct. And you can easily get the distinct count value via UI. Please see: count distinct on column in power query.
Alternatively, you can try Imke Feldmann's solution.
Regards,
Yuliana Gu
1 Reply
Hi polaris3028,
You can use Table.RowCount and Table.Distinct. And you can easily get the distinct count value via UI. Please see: count distinct on column in power query.
Alternatively, you can try Imke Feldmann's solution.
Regards,
Yuliana Gu