Create 12 Monthly Budget columns in Power Query

[hananak]

Dear All,

I was wondering if you could help.

I have an Annual Budget Column in Power Query. I want to divide it by 12 to get the monthly Budget and then have the result in 12 monthly columns using power query. I have done it using 12 steps. But is there any way to do this in 1 step?

Example:

Annual Budget : M1 - M1 - M2 - M3 - M4 - M5 - M6 - M7 - M8 - M9 - M10 - M11 - M12
12,000 : 1000 - 1000 - 1000 - 1000 - 1000 - 1000 - 1000 - 1000 - 1000 - 1000 - 1000 - 1000

 

[hananak]

In your original query change the name of the appropriate column to Annual Budget. The add the steps to the end (but use the new last step name instead of #"Replaced Value" in the three lines of code)

Thank you very much for your time and effrots. Finally, the issue is resolved and it is working perfectly as I wanted.