Power Query

[bfreescott]

Hi guys,

I have a report that I regularly refresh with a new table of data. Right now the values in my report are pulling from the table using sumproduct formulas since the values have to meet a wide variety of criteria and I don't want to go through all the necessary redefine/refresh steps associated with having various pivot tables.

I read somewhere that Power Query gives you the ability to do that. Does anyone have experience or a good resource for setting up Power Query to pull values into cells that meet the given criteria with a simple button execution?

 

[Matt Allington]

Yes, power query can do most anything like this. But your question is very general. You could read this book.

M is for Data Monkey Book Review - Excelerator BI