Forum Discussion
PowerQuery - Table.Profile() not able to calculate
Hello, I have the following problem with Table.Profile() function. Standard output is as follows: I need to perform Table.Profile() on table that has 130 columns and around 2 milion of rows...
I'm reasonably sure you can write your own version.
Unpivot the columns and Add a Custom Column (if value is "" then 1 else 0)
perform a 'Group By' with 2 aggregations (Count rows and Sum of the custom column)
Let me know how you get on