Date Range From Input Parameters in Calculate DAX

Date Value 6/13/2019 3 6/13/2020 4 6/13/2021 7 I have a table of dates and values and I want to find the difference between the sum of values of a current period and a previous...

Need Help

Anonymous

3 years ago

Hi Anonymous ,

I have created a simple sample , please refer to my pbix file to see if it helps you.

Create 2 measures.

Previous Period(Measure) =
VAR _1 =
    EDATE ( MAX ( 'Table'[Date] ), -12 )
VAR _2 =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Date] = _1 )
    )
VAR _3 =
    IF ( _2 = BLANK (), BLANK (), _2 + MAX ( 'Table'[Value] ) )
RETURN
    _3

Measure =
VAR _1 =
    EDATE ( MAX ( 'Table'[Date] ), 12 )
VAR _2 =
    SUMX (
        FILTER ( ALL ( 'Table' ), 'Table'[Date] = _1 ),
        [Previous Period(Measure)]
    )
VAR _3 = _2 - [Previous Period(Measure)]
RETURN
    IF ( _2 = BLANK () || [Previous Period(Measure)] = BLANK (), BLANK (), _3 )