CALCULATE PREVIOS ROUND

[ngocnguyen]

Hi all

I have a TABLE 1 as below

I build up a Dax formula to calculate the previous round as below, but it not working. Could you pls help to check?

Amt_previous round =

VAR preroundindex = SELECTEDVALUE(Table 1[Round index]) -1

RETURN

CALCULATE(Sum (Table 1[Amt]), Table 1[Round index]=preRoundselected)

[Jihwan_Kim · Accepted solution]

Hi,

I guess the column [Round] is sorted by [Round index] column.

Please try the below whether it suits your requirement.

Amt_previous round =
VAR preroundindex =
    SELECTEDVALUE ( 'Table 1'[Round index] ) - 1
RETURN
    CALCULATE (
        SUM ( 'Table 1'[Amt] ),
        FILTER ( ALL ( 'Table 1' ), 'Table 1'[Round index] = preRoundselected )
    )

[ngocnguyen]

Thanks so much for your support