Forum

Hi Julian, First, you have to provide a table with text links, not hyperlinks attached to cells, power query will not read hyperlinks. However, ...

When there is a formula that returns zero length strings, those are not seen as blanks, but you can evaluate instead the length of the text in that ce...

As I already said, "... you cannot have more than 1 timer procedure running at a time." There is no way to force excel to accept more than 1 code in t...

Hi Algemron, File.Contents needs a file path, not a folder path. Try starting the query using From Folder option, not from File, then change the...

Hi Kelly, in Excel 2016 there is no separate tab for Power Query, in this version PQ is integrated in excel, it's no longer an add-in. You will fin...

Hi Kim, An excel sample file instead of a picture would be more helpful, can't see your complete data structure. You have worksheets named Jan, ...

Hi Logan, Please check the attached file, there are a few samples on how to make calculations based on selected dates from slicers.

Changed your relationships, see if this works as expected.

Hi Mark, Try adding to that report the Brand from Brand table, not from Cars table, see how it works

Hi Mark, The download link is not functional, can you try again uploading your sample?

You don't need to make complicate things. Assuming that you load employees table in a query named Table1, and the list of courses is in a query nam...

Hi David, The syntax you used or List.ContainsAny does not seem to be right: List.ContainsAny([ShortID],#"MyExclusions",[ShortCode]) The functi...

Hi James, You should setup a shared excel file using OneDrive, or even google sheets, you will be able to connect to that file from Power Query. ...

Hi Parveen, What is A diff-diff header? Never heard of it. Power Query is your best option, you will be able to configure the import yourself fr...

Hi David, Can you upload a sample file with your tables? Hard to see the problem without sample data.