Forum Discussion
Solved
Getting 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...
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)
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)
OMG 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!!