Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Reference Sliced date in expression

I need to create a measure that, as part of its calculation, knows what the date range from the date range slicer is?   Each row of data is date and time stamped so I can reeference that, but bette...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    If you add Table[Date] in slicer, and you select a date range in slicer, you can create a measure using formula below to get the latest date of the range in slicer.

    Latest Date in slicer =
CALCULATE ( LASTDATE ( Table[Date] ), ALLSELECTED ( Table ) )


    Then you can use the meausre [Latest Date in slicer] in another DAX expression.

    Best Regards,
    Angelia

jreade's avatar
jreade
Frequent Visitor
8 years ago

I think I want to do something very similar. I would like to create 2 multi-row cards of data. I have a relative date slicer. The first card would display the data for the timeframe selected by the slicer, while the second card would show the data from the previous period for the timeframe selected by the slicer. For example, if you selected this 7 days in the slicer the second card would display the 7 days previous. If you selected this 3 months in the slicer the second card would display the 3 months previous. Ideally, you would be able to select any range of dates and the second card would calculate the range selected and determine the timeframe of the previous period.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi jreade,

     

    I can give it a try.  Share the link from where i can download your file.