Jamie Thomson on 23 Apr 2015 01:34:46
When in Excel I can select a range of cells and, if they're numeric, will show the following information in the footerbar:
Average
Count
Sum
I would find it useful to be able to do the same in Power Query (both when using PQ in Excel and also in PBI Designer). Currently if I select a cell in the results of a PQ query then a box appears at the bottom and shows that selected value (does in PBI Designer anyway, haven't tried this in Excel). That seems like a great waste of what is a rather large box. Why not fill it with something useful such as Average/Count/Sum just like in Excel.
Or even, given the box is so darned big, do something like really funky like automatically display a PowerView report in there. Lots of possibilities I'm sure.
Administrator on 10 Jun 2021 18:30:03
Column profiling exists in product - https://docs.microsoft.com/en-us/power-query/data-profiling-tools#column-profile