Forum Discussion

mterry's avatar
mterry
Helper V
2 years ago
Solved

Duplicating rows with udpated data in Power Query

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 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mterry ,

     

    Thanks for the reply from aj1973 , please allow me to provide another insight: 

     

    1. Filter last month’s data in power query.

     

    2. Copy the current table and modify the column names of the two columns of dates.

     

    3. Create custom column.

     

     

     

    4. Remove unnecessary columns.

     

    5. Append the copied table to the original table.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mterry ,

 

Thanks for the reply from aj1973 , please allow me to provide another insight: 

 

1. Filter last month’s data in power query.

 

2. Copy the current table and modify the column names of the two columns of dates.

 

3. Create custom column.

 

 

 

4. Remove unnecessary columns.

 

5. Append the copied table to the original table.

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • mterry's avatar
    mterry
    Helper V
    2 years ago

    Thank you that's exactly what I needed.