Using a Modify Row Button I am trying to move the values form one month column to the next, but instead it populates all the values from the next column in each row of the target month column.
This is the Formula. How would I get it to populate from one row to the next specifically?
[Monthly Forecast Spend].Formulamap(currentValue.ModifyRows([Monthly Forecast Spend].[Current Month], [Monthly Forecast Spend].[Next Month]))
Any help is appreciated! Thank You!