Forum

You can try Power BI Desktop, Power Query is stronger there and has the PDF tools, it's free. (at least, there is a free version)

Hi Frantisek, Without a sample file, it's hard to help you. Can you upload one?

Which is the expected result? please provide a sample file and an image of how you want the result to be.

Hi Tony, Please check the file attached, see if that solves your problem. Looks more like a math problem, not excel.

Hi Lakshmipathi, You can''t use both, If you want top 5, don't use the slicer, what''s the point of having a slicer when only 5 values are listed? ...

Hi Alan, The query results are not stored in memory, dependent queries will run again the initial query to load data. Try loading the first query t...

Hi Kent, You are pasting 3 queries into 1, the 2 queries from the bottom should be separate queries (Transform File and Sample file)

There are 2 buttons, one next to the other: one is for selecting a file, the other is for start upload. Using only one of them is not enough.

Hi, May and August have N/A values, the red lines cannot start from these values. You will have to adjust those formulas to start showing the li...

The output destination is not controlled in M language, so there is no way to write in the query the destination sheet. (yet) Only VBA can help...

The output destination is not controlled in M language, so there is no way to write in the query the destination sheet. (yet) Only VBA can help...

Hi Thulasi, A calculated field in a normal pivot does not add the results below row fields a new rows, it is added as a calculated column. You c...

Workbooks("filename.xlsm") requires the source file to be open, make sure it is. Check also if sheet name is indeed Schedule-A

Hi , Have you tried this?

Hi John, There is no attachment, please try again.