Forum Discussion

JorgePereira's avatar
JorgePereira
Helper I
6 years ago

Measure within Calculate

I have a problem here that I can't solve ... I have a measure: Total Acum Plan =      CALCULATE ([Total]; Base [Version] = "IF4";          DATESBETWEEN (          Base [Date]. [Date];          ...
Need Help
edhans's avatar
edhans
Community Champion
6 years ago

Use a VAR/RETURN block in your measure.

 

Total Acum Plan =
VAR Plan = "IF4"
RETURN
    CALCULATE(
        [Total],
        Base[Version] = Plan,
        DATESBETWEEN(
            Base[Date].[Date],
            DATE( 2020, 1, 1 ),
            [_Date Report]
        )
    )