Forum Discussion
My Query seems to always return a Function or an Error
Hi kmcardle
Do you want the result to look like this:
If so then you can create a new column with this code
let _id = [ID] in List.Count(List.Select(#"Changed Type"[ID], each _ = _id))Regards
Phil
Wow. Exactly what the doctor ordered. Thank you!
Kevin
Hi kmcardle
If you are trying to count the number of records with the same identifier, you could do that by Grouping the identifier and setting the Aggregation to Count, for example:
If that doesn't suit your needs, please post some sample data and an example of the result you are looking for.
Regards
Phil
Thank you Phil. How then would I populate a new column with the count? BTW I really appreciate that you provided such a great answer. Thank you.
Hi kmcardle
Do you want the result to look like this:
If so then you can create a new column with this code
let _id = [ID] in List.Count(List.Select(#"Changed Type"[ID], each _ = _id))Regards
Phil
Wow. Exactly what the doctor ordered. Thank you!
Kevin