I'm working on one report which requests to calculate the monthly YTG running total based on the actualized YTD value as below. That YTG value will keep update since we will actualize YTD data month by month. (see below fomula)
C = last month leftover (B-A) + this month B - this month A
Here I marked the actual value in orange and calculated value in yellow on both Jun table and Jul table.
By the end of Jun, Jul C is calculated. Jul C = Actualized Jun C + Jul B - Jul A = 7+12-13 = 6
By the end of Jul, Jul C is actualized as 8.
same as the following months value.
(A, B and C are from the different tables, so I can apply summarize dax to combine A, B and actualized C into one table). SO, how should i calculate in BI? In order to make sure that YTD C value is always actualized month by month and YTG is calculated based on the latest month's actual value. Thanks!