Forum Discussion

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 years ago
Solved

Dynamic Date prior period value

Hi,   I have date slicer and I want prior period value.   suppose I select 15-31 January date range then I want prior period sum value from 1-14 January.   A need the sum of (column A, co...
Need Help
adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 years ago

Can I get DAX for this ...what I wrote is giving the only month before data.

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi adityavighne 

You may create a calendar table and use below measure.Attached sample file for your reference.

Measure = 
CALCULATE (
    SUM ( Data[Column1] ) + SUM ( Data[Column2] )
        + SUM ( Data[Column3] ),
    FILTER (
        Data,
        Data[Date] < MIN ( 'Calendar'[Date] )
            && MONTH ( Data[Date] ) = MONTH ( MIN ( 'Calendar'[Date] ) )
    )
)

Regards,