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
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