Forum

Hi Casey, Thanks for sharing the sample file. You can use a conditional column to extract the VAT types from the first column and then copy down. S...

Hi Amar, 1. Not sure why it's ignoring the defined tables. 2. In this tutorial on getting multiple files containing multiple sheets using Power ...

You can copy the M code/query by selecting the query in the 'queries and connections' pane in Excel, then CTRL+C to copy it. This will copy the M code...

Yes, please share, Miko. Thanks for asking 😉

Not sure, sorry. As a general rule I try to keep my source files closed when refreshing.

Hope you're feeling 100% soon, Peter!

Good point, Hiroto. You'd need a hidden row containing dates that aren't formatted with the TEXT function that you'd use to refer to in the conditiona...

Hi Luke, I'd use a PivotTable if I were you. Please see attached. Mynda

You can use the TEXT function to change the formatting of the dates returned by SEQUENCE to suit the periods selected in the Radio Buttons. You'll nee...

ExcelNovice, you haven't said what type of file 'test' is. If it's an Excel file then it must be closed for Power Query to refresh properly, so this m...

Hi Miko, Welcome to our forum! The Pdf.Tables function has a parameter for multiple pages. Have you tried setting this to TRUE? Mynda

Hi Mark, I'm not sure what would be causing this and I can't replicate it. Have you tried different report layouts? i.e. go to the Design tab and i...

Hi Hiroto, Welcome to our forum! You can use an INDEX formula to toggle between different time periods. See file attached. Mynda

Hi Jen, You can get the 2021 data from separate files using Power Query, but you would then need to append that to the 2020 table of data that's lo...

Hi Chad, It sounds like you haven't got enough RAM in your PC. You should also check you have the 64-bit version of Power BI installed as this will...