Forum

Hi Richard, You can share the PDF if there's nothing confidential in it if you like, but it shouldn't be difficult to copy and paste the table from...

Hi Richard, Please create a mock up Excel file containing your data (without the link to the PDF) in it's before format that covers the scenarios y...

Hi Richard, Adding custom columns is covered in session 4.13, however I recommend you use the simpler Conditional Column technique covered in sessi...

I believe my answer solves this problem because it finds the last date and time in the data set and then filters based on that. As you refresh the dat...

Hi Ahamd, There's no formula based solution for this because formulas cannot detect relationships that are indirect, i.e. route via multiple tables...

Hi Richard, You can add a custom column that checks if the text in Trips = "Minutes" and if so, it brings in the value from the Minutes column othe...

Hi GK, You can extract the Latest Date from the Data_Between_Dates query and then use that to filter the data in the Data_Latest_Date table. See fi...

Hi Lea, Please see this tutorial on Absolute References in Tables. Mynda

Hi Charles, Welcome to our forum! Thanks for sharing your file. You didn't give an example of the desired result, but going by the highlighted colu...

Hi Ahmed, As answered to the same question you posted on YouTube: If you use the Country Name from Table 1 and the Profit from Table 3 in a ...

Hi Ahmed, Use Sparklines or small multiples for this. Mynda

Hi Derek, Format each table that you want to import to Power Query as a proper Excel Table (CTRL+T or Insert tab > Table). You can then load tho...

Hi Michael, Welcome to our forum! Those ghost windows are a bug that have also been seen by some of my fellow Excel MVPs. I'm not sure what the ...

Hi Joerg, Welcome to our forum! Please provide a sample Excel file so we can help you further. Mynda

Hi Danielle, Yes, you can number grouped data in Power Query (see link). Mynda