How to add row of one column to row of another column?

[Anonymous]

Hi in Below Table I would Like to calculate the row YTD and next Initial FC in one column, Please see my example below, Please let me know if anyone can provide me the DAX query for same.

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

1. Add an index in the Query Editor.

2. Add a calculated column with the following formula.

Column =
VAR initial =
    CALCULATE ( SUM ( [YTD] ), FILTER ( 'Table1', 'Table1'[Index] = 1 ) )
VAR currentIndex = [Index]
RETURN
    IF (
        [Index] = 1,
        0,
        initial
            + CALCULATE (
                SUM ( Table1[Initial FC] ),
                FILTER ( 'Table1', 'Table1'[Index] >= 2 && 'Table1'[Index] <= currentIndex )
            )
    )

Best Regards,

Dale