![]() = Table.AddColumn(#"Replaced Value2", "Answ'd", each List.NonNullCount(List.Range(Record.FieldValues(_),3))) 2) I can replace all blanks and 0 values with nulls and then add a column this way (list.range used to exclude the first few columns): But that seemed like one step too many and in the past I have sometimes experienced PQ refresh performance issues, depending on the size and source of my data. 1) I can reference my query then pivot/unpivot and perform a count and then merge both queries. I already figured out a couple of options. I want to figure out the most efficient way of doing this in PQ because there are other transformation steps I perform prior to loading to the data model. It feels like there should be a pretty efficient way of doing this in Power Query. In the past, in Excel, I would add a column with the formula countifs(rng1,"",rng1,"0") and call this "Answered" (abrev: "Answ'd") as in how many items did the respondent answer. I have survey data I work with that typically has about 50 columns or more. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |