Dynamic Date prior period value

[adityavighne]

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, column B, column C) 1-14 January

[Anonymous]

@adityavighne - It should be possible, but you need to clearly define the rule in order to modify the filter context. Is this the rule?:

1. Find the minimum date.

2. Find the month for that date.

3. Filter on only dates that are before the minimum date and within the same month.

Cheers!

Nathan

[adityavighne]

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

[v-cherch-msft]

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,

[adityavighne]

This measure showing blank value

[v-cherch-msft · Accepted solution]

Hi @adityavighne 

You may drag only the date column and measure to the visual.

Regards,

[Anonymous]

Hi @adityavighne ,

I think, prior period date range is not possible, only for a single date is possible.

Like, if you select January 2019,
can get the previous month, means December 2018 or
can get the current month last year, means January 2018.

Regards,

Pavan Vanguri.