Forum

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 ...

Hi Sharon, You can use Power Query to clean this data. You can use the Referencing next row in Power Query technique described under the heading "R...

Hi William, Welcome to our forum! I think if there were any performance differences it would be negligible and probably depend on the complexity...

Hi Andrea, I'd say you'd have to create 4 separate charts because the second vertical axes within each group (In/Out) are different. Mynda