Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic Measure by Date Slicer

Hi Everybody,

I need help to create a measure that counts the only the latest entry on a column, and is affected by my date slicer.

sample data
For example, if a have a date slicer on the 30/11/2018, the measure will only count the id=2 entry, if the date is earlier than 23/11/2018 the measure will count the id = 1

Thanks
Vhar

Date
DAX
Measures
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Hi Anonymous ,

     

    Try this:

     


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

    id select = var _dateselected = max(DateSlice[date])
var _lessdate = If (Max(DateSlice[date])<=_dateselected,    MAX(DateSlice[id]))

return _lessdate

     

2 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

     

    Try this:

     


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

    id select = var _dateselected = max(DateSlice[date])
var _lessdate = If (Max(DateSlice[date])<=_dateselected,    MAX(DateSlice[id]))

return _lessdate

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Nathaniel_C 

      Thank you,

      The measure is working just like I needed.