Forum Discussion
Solved
Count text value items in row
Good day everyone I have a table in Power BI imported, the number of columns is about 400, and the rows are around 190. I need to calculate text value items for each row separately. for example h...
You would need to do this in Power Query.
Insert a custom column and use following formula to calculate no. of Yes
= List.Count(List.Select(Record.ToList(_),each _="Yes"))For no. of No information
replace Yes with No information in above formula.
You would need to do this in Power Query.
Insert a custom column and use following formula to calculate no. of Yes
= List.Count(List.Select(Record.ToList(_),each _="Yes"))For no. of No information
replace Yes with No information in above formula.
Thanks so much for your quick replay, worked very well!
