Forum Discussion
Helper IIIGetting List.Count for each column Power Query
Hello,
I have a table like this:
I have been trying to find a way to convert each column so that they are a count of the number of items in each list for each row. One company used to have multiple rows and I used the Group By function first, then Aggregated Rows using List.Distinct so it have me a the result above. The end goal is the count within each list. I have been having the hardest time and am hoping I can avoid having to manually make a custom column for each one since I have like 30 columns. Any help is greatly appriciated.
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjFLL9CsEaSzn-65a?e=ENQDED
= List.Skip( Table.ColumnNames( from),1) = Table.ReplaceValue( from, (x)=> x,(x)=>x, (x,y,z)=> List.Count(x), listmy)
2 Replies
- Ahmedx
Super User
to know how to do this watch my video
https://1drv.ms/v/s!AiUZ0Ws7G26RjFLL9CsEaSzn-65a?e=ENQDED
= List.Skip( Table.ColumnNames( from),1) = Table.ReplaceValue( from, (x)=> x,(x)=>x, (x,y,z)=> List.Count(x), listmy)
ACraig08OMG that was amazing! You also taught me how to had a function/step without having to chose one of the ones from the ribbion! I didn't know you could select the symbol to insert your own thing! Thank you!!