Dynamic Measure by Date Slicer

[Anonymous]

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

[Nathaniel_C · Accepted solution]

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]

@Nathaniel_C 

Thank you,

The measure is working just like I needed.