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

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

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