Forum Discussion
Power Query: Extract distinct values from column as new query
Hi, I have a fairly large query with 1,5 million rows, which is growing by around 5000 rows per day. From that query I want to extract the distinct values from one specific column and create a ne...
Hi Anonymous,
You can try to create a blank query to reference original source, then use list.distinct to remove duplicate records.
let DistinctSource = List.Distinct(Sheet2[Date])// List.Distinct(QueryName[ColumnName]) in DistinctSourceSheet2(22582 rows) -> Date(953 rows)
Regards,
Xiaoxin Sheng
Hi Anonymous,
You can try to create a blank query to reference original source, then use list.distinct to remove duplicate records.
let
DistinctSource = List.Distinct(Sheet2[Date])// List.Distinct(QueryName[ColumnName])
in
DistinctSource
Sheet2(22582 rows) -> Date(953 rows)
Regards,
Xiaoxin Sheng
I have a question for this. I am trying to do this myself:
you write // List.Distinct(QueryName[ColumnName]), is this the new query you're working in?
If not, what is it?