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,

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

        This measure showing blank value