I have two different books, one is fruit and other result.

I’m trying to create a dataflow with power query for currency conversion rates. I have an excel file that has the rates I need, the issue is that the rates for the current month aren’t updated until the end of the month and sometimes they’re needed before that. What I’m trying to do is to use the rates for the latest month until they actually get finalized. So I’d like to duplicate all rows for the last month in the file, update the month columns by one month and keep the rates the same. Here’s a sample of the data now:

I’m importing a PDF file into Power Query and parsing as necessary. The source folder name is static, but the file name itself can change.

I’m trying to copy some tables into a single table, the addresses are held in a table called DataSource. I’m using the code below but getting an error where the expression error, value is mismatched so is not putting the table together here is my code:

I am working through Microsoft’s TripPin Custom Connector walkthrough tutorial. In Part 7 there is a section on refactoring some code into separate .pqm files and referencing these from the .pq file.

I am trying to convert this table:

I want to build a PowerBI report using many excel files from a folder. I want this report to be dynamic and be able to load all the files by itself.

Please for your help!

I want to load data daily from SQL to Lakehouse using Dataflow.
My technique is to get the maximum DateCompleted and get the data from MySQL bigger than this value.
I have 2 queries in my dataflow. The first “PGW_Payment_Transactions_LH” calculates the Maximum Date/Time from DateCompleted Column from the table in Lakehouse.

I am trying to add a custom column based on the length of the Text column which is column 1 (which contains text and ID numbers). but the code below gives error. is there a way to fix this ?