Forum Discussion

Frequent Visitor

4 years ago

Solved

Create a new table with distinct values

Hi I am trying to create a new distinct table. My source data has the following fields: Store ID, Department, Month, Total Sales I need understand how I can create a table which will display t...

Need Help

amitchandak
4 years ago
DaleK , Based on What I got

Summarize(Table, Table[Department], "Stores", count(Table[Store ID]))

refer

Summarize - https://www.youtube.com/watch?v=qE5KBp4uP0g

Or use Group by in Power Query

https://docs.microsoft.com/en-us/power-query/group-by

amitchandak

Super User

4 years ago

DaleK , Based on What I got

Summarize(Table, Table[Department], "Stores", count(Table[Store ID]))

refer

Summarize - https://www.youtube.com/watch?v=qE5KBp4uP0g

Or use Group by in Power Query

https://docs.microsoft.com/en-us/power-query/group-by

Forum Discussion

Create a new table with distinct values

Related content

Create a new table with distinct values

count distinct

Create New Table Based on DIstinct Values of One Column and Calculated Values of Another Column

Index DISTINCT values

How to cound real distinct values?