Forum Discussion
Solved
Duplicate rows based on criterias
Hi, I've searched the forum and didn't find any solution that looks like with my issue. I have a data set of accruals by month, and the amount needs to be reversed in the following month i.e: ...
Hi Thiago_Font ,
You can add three custom columns in Power Query Editor.
You can download my attachment for more details.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think you could do this by duplicating the table, filter to keep only the "Accrual" rows and add custom columns for the values required (Month, amount, mov.tp ) - these columns will need a different name but you can create them, remove the original columns and then rename to get what you want).
You can then append this table with the original table.