Forum

Hi Pieter, Best is to start the macro recorder, to get the piece of code you need. That's what I did, here is the code generated to update a spe...

Hi Amien, A pivot from that data will never work, structure is simply wrong. Mixing source data with a visual is a bad idea, any report that wil...

The folder dialog is there to ask you where you want to save the generated PDF, not to open all excel files from there. You can use sample code fro...

List.Max cannot be used on text values, will apply an alphabetical text sorting, in your example list.max will return the text that starts with USA......

Really don't understand what you mean. I tried your query, with both scenarios: -adding "/aaa" at the end of the third value, -adding "aaa/" ...

I'm not able to open your pbix file, it's incompatible with my PBI version (Version: 2.84.981.0 64-bit (August 2020)) Can you provide the example o...

Hard to understand how you need to have the result, I'll have to guess. I'll assume that you want to split into 5 columns AND keep whatever is afte...

Try Web instead of Files: Source = Excel.Workbook(File.Contents("C:UsersCatalinDesktopCopy of 2_1_2a21_smc.xls"), null, true), Source = Excel.Workb...

You cannot split each row into separate columns. Add a column with Text.Split , you can pass a different separator to each row. The result will be ...

Hi Javier, Try this query: (You should replace the path to the file with yours) let Source = Excel.Workbook(File.Contents("C:UsersCatalin...

Hi, Can you upload a sample source file with those multiple sheets?

You will have to reorganize the data. Are you familiar with power query?

Hi Nikolai, Never seen this before, unfortunately. However, I'm not an intensive SP user, hope others can help.

Hi Stephanie, You can reuse the code you have: With Workbooks.Open(xFdItem & xFileName) create_and_email_pdf ' that's all you need, th...

Hi Pieter, RefreshAll does not take parameters. Instead of RefreshAll, you have to specify each pivot you want to refresh: Sheets("Sheet1").Pivo...