Dynamic Measure by Date Slicer

Question

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 dataFor 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 = 1ThanksVhar

nathaniel_c · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Try this:&nbsp;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&nbsp;id select = var _dateselected = max(DateSlice[date])
var _lessdate = If (Max(DateSlice[date])&lt;=_dateselected,    MAX(DateSlice[id]))

return _lessdate&nbsp;

Forum Discussion

Related content

Dynamic measure filtering

Dynamic Subtitle with Hierarchy Slicers

Power BI Dynamic Filter/Slicer

Show slicers dynamically

Dynamic Measure developement