Forum

Hi Catalin, Thanks for taking the time to add the explanation. It really helps. Bax

Hi Catalin, Your solution works really well. Do you have any explanation as to how this works as I would like to understand it a bit more so I can ...

Hi Anders, File attached now has a query added. I want to somehow combine the two queries in the file to fill in the missing weights in the Query_d...

Hi Anders, Exactly what I needed. I knew it was possible but was missing the Don't aggregate values piece. Thanks for taking time to provide an ans...

Hi Mynda, Exactly what I was after. I couldn't work out how to do the second index bit. Thanks for the response. Cheers Bax

Hi Phil, I am not looking to hide the sheets I just don't want to display the tabs. In the desktop version you can turn the display off by going to...

Hi, Thanks for the replies. Is there any way to remove the queries and unlink from the Data Sources en masse? I have quite a few queries and data t...

Hi, I managed to find a couple of ways to do this in power query, one is to create a query that calculates the averages and then merge that query w...

Hi Anders & Mynda, Thanks for the input. I was hoping to limit the number of columns showing the consultant information as in the full data tab...