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.
2 Comments
Column profiling exists in product - https://docs.microsoft.com/en-us/power-query/data-profiling-tools#column-profile
- Status added:Completed
