Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Average/Count/Sum cells when selecting them in Power Query

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.
Status: Completed
Comments
nishalit
New Member
fbcideas_migusr
New Member
Status changed to: Completed