Forum

Hi Michael, Great to see you're giving Power Query a try. I recommend method 2 because this will be more efficient for Power Query. Once you hav...

Hi, Use the "SEARCH Not Case Sensitive Array Formula" and change the ROW reference to match the number of items in your 'List'. e.g. if you add one...

Hi Alison, You can use PARALLELPERIOD or SAMEPERIODLASTYEAR for this. See file attached. Mynda

Hi Alison, It may be something that you should use PARALLELPERIOD for, but without knowing the context I can't be sure. Please provide a screens...

You could try creating a Named Set as Velouria suggested.

Hi Mark, Just thought...you could create a 'Set' for your YTD figures as described in video 11.01 of the Power Pivot course. Mynda

Hi David, Yes, they're inevitable because you have the Month column in the column labels. Mynda

Hi Anne, I presume you have a new folder for the 2019 source files. In which case, make a copy of the Excel file containing the 2018 query. This wi...

Hi Georgie, Power Query is the only thing that can add data to the bottom of a Power Query table. If you want to add data then you add it to the so...

Hi Alison, Try a custom format like so: =FORMAT(DIVIDE([# SUN's]-[# SUNS Prv Year],[# SUNS Prv Year],BLANK()),"0%")& " Decrease") Mynd...

Hi Alison, Unfortunately not, sorry. Mynda

Hi Mark, AVERAGEX won't calculate a YTD value. If you look at the first image you can see the value for YTD Score is the same every month. Also, yo...

Hi Arun, Please see attached. Mynda

Hi Arun, Dynamic calculations like this are possible in both Power Query and Power Pivot. My concern is that you shouldn't be doing a calculation l...

Hi Arun, Thanks for clarifying and sharing your file. I'm a bit concerned because this data isn't in a tabular format i.e. you should have 3 column...