Forum Discussion
Solved
Distribute Value to Months from Start Date
Hi Team I need your support I have a based table as below Table 1: Title Start Date Distribution Months Value ABC 23-Mar-23 4 100 BCD 2-Apr-23 12 200 CDE 15-Dec-23 2 ...
Hi rsmahes
You have an m code exactly for your scenario here :If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi Ashish
In yours the date is reflecting same but it has to be incremental
Ashish_Mathur
Super User
Super UserHi,
In the Query Editor, use the Date.AddMonths function to create another column.