Last seen: Jul 24, 2026
Hi Diane, Welcome to our forum! We're not SharePoint experts here, but I'm pretty sure you have to give your users permission to the source data fi...
Hi Rosemary, Because your time series are going across columns, whereas mine were in the rows. It's therefore, giving you the total percentage chan...
Glad you figured out a solution. Your example data did not illustrate that the region could sometimes be in the middle, nor did you explain that in...
Hi Lavan, Welcome to our forum! It's not clear why you need Show Items with No Data turned on. It seems pointless to display November and Decem...
Hi Rutger, Welcome to our forum! In my experience it's easier to create your report from Excel and print to PDF rather than export/import to Wor...
Hi Harnek, Welcome to our forum! You'd probably need to write some VBA code to achieve this. Mynda
Hi Bax, You can use Add Column > Extract > Text before delimiter for the location and text after delimiter for the shift. The lookup tables a...
Hi Fran, If you look at the PivotTable on the Pv_fwd_PC sheet the Period Name filter doesn't include October. If you refresh the PivotTable, the Ne...
Hi Aye, Please see this Power Query approximate match vlookup tutorial. Mynda
Hi Dave, See file attached. I used Lionel's clever formula and this formula to get the row number (there might be a more efficient way, but I didn'...
Hi Mattias, Thanks for sharing your files. You need to use Change Type > Using Locale covered in lesson 4.03 of the Power Query course. You'll s...
Marking it as the date table is only important if you want to use the Time Intelligence DAX functions. If you want to do that, then you'll need a sepa...
Ah, I didn't realise you were still using Excel 2003. I thought you had just saved the file in the 2003 format! I see Anders has done a great job of h...
Hi Stephan, Not sure why you're keeping the file as a .xls format. I recommend you save it as a .xlsx file. Anyhow, if you delete the COUNTA par...
Hi Fran, No workbook attached. Be sure to click the Start Upload button after selecting your file and then wait for the grey check mark beside the ...