Solved: Re: distinct column in a table

Krishna09 · ‎11-11-2022

How to figure a distinct column in a table? I mean like alternate key column.

ImkeF · ‎11-11-2022

Hi @Krishna09 ,
you can apply the Table.Profile function to your table and check where "count" = "distinct count"

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

ImkeF · ‎11-11-2022

Hi @Krishna09 ,
you can apply the Table.Profile function to your table and check where "count" = "distinct count"

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

distinct column in a table