Last seen: Jul 3, 2025
What is a SharePoint Map? Is that a sharepoint site documents? If yes, you can simply Sync that folder locally, and you will always have files sync...
Hi Maarten, See this post for a solution, download that file attached:
It would be appreciated if you would kindly provide me with the code to do this Hi Howard, That's exactly what I did, you have in the previous...
Salut, If you have tried to find in Power BI the same functions from excel, you should know that they are not the same, you have to build the calcu...
Or, you can use the loop with the entire table, and use the Replacer function: TransformStep= List.Accumulate({".DWG",".TIF",".ZIP","-","&"},#"Tri...
Or, You can use the same power query loop I explained to you in your previous post: The loop will be: = Table.TransformColumns(#"Trimmed Tex...
Attached a sample file that reads a folder with csv files. The path to the folder can be set in settings sheet, then just refresh the data table. ...
This is one of many reasons for NOT to use automatic file combiner. However, you can simply apply a filter on the first column to remove records th...
There are many more issues in your code. You have 2 lines with If...Then, but only 1 End If closing line. Second issue: move static parameters l...
Glad to hear you managed to make it work. Best, Catalin
Looked into your file, and you have multiple tables in the Custom column. To get all headers (on some rows there may be different headers), you hav...
Instead of {"Column1", "Column2", "Column3"}, simply READ the existing column names dynamically from the previous step: Table.ColumnNames(#"Added C...
I thought it's obvious that what I provided is for formatting all columns. You don't have to go manually and expand the new columns, that's what Ta...
Hi Chris, You can use an iterative function to loop through all columns. When you change a column format, this is what PQ generates: = Table.Tra...
I guess you can check the third column, rows 24 and 50: If range("C24")="" then...you can hide the range between rows 24 and 50 If range("C50")=...