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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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'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,