Making static column dynamic and mapping the column again to its data

[iCFO]

I re-read your first post. I think that you want to select the prior month from the current month of run time, then rename that column to something static for formula use, then return it to the original column name. I would need a workflow to try and tackle this as it will require a few steps and column name variations could require different method approaches. Here is something to get you started.

You can get the current date info at execution time using this approach.

Add Current Date

Hi @SergioSB , current date and time is something I’d almost expect there to be a dedicated node for, but strangely it’s a little hidden in less obvious nodes. Here are a couple of options You can use Date&Time Configuration [image] [image] Note that I added a flow into Date&Time Configuration to ensure that it is reset and re-executed if the workflow is re-run to ensure current execution date. Set the return type to Date, and tell it to return execution time. Variable to Table Column can …

Then Date & Time Shift set to Month and -1

Then Date & Time Extract to get the month and year in a separate column.

Then Column Expressions to make the month and name formats match your column names / combine them so they match your column name format.

Then convert that to a flow variable to and use it with the Column Renamer to switch to a generic name

Then use the same flow variable to return to the original name using a Column Renamer after your formulas.