Movement in Water fall chart Help

Hi Anonymous ,

Based on my test, I could only do this:

Measure = 
VAR _curr =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( 'Table', 'Table'[YearQuartre] = MAX ( 'Table'[YearQuartre] ) )
    )
VAR _pre =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[YearQuartre]
                = MAXX (
                    FILTER ( ALL ( 'Table' ), [Date] < MAX ( 'Table'[Date] ) ),
                    [YearQuartre]
                )
        )
    )
RETURN
    IF (
        HASONEVALUE ( 'Table'[YearQuartre] ),
        _curr - _pre,
        SUM ( 'Table'[Value] )
    )

In this case, I suggest you import Simple Waterfall or Ultimate Waterfall Free 4.4.6 or Waterfall Cahrt by Visual BI visual like this:

Measure 2 = IF(MAX('Table'[YearQuartre])= MINX(ALL('Table'),[YearQuartre]),0,SUM('Table'[Value]))

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.