Use Distinct Count in Power Query Editor to Create a Calculated Column

[polaris3028]

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

[v-yulgu-msft · Accepted solution]

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