To use the DISTINCT keyword, you simply place it after the SELECT keyword and before the column names that you want to apply it to. For example, if you have a table called customers with columns ...

In the Power Query Editor, select the column you want to count distinct values for. Go to the Transform tab and click on Group By. In the Group By dialog box, select Advanced. Add a new aggregation ...

This pattern explains how to perform SELECT DISTINCT by using queries in Microsoft Dynamics NAV. It is brought to you by Bogdana Botez from the Dynamics NAV team here at Microsoft Development Center ...