Forum Discussion
Define Category based on Dates
Hi All, How can I define what was role of the employee at selected point of the time? My model is little bit tricky due other purpose. Please see below scheme of model. Arrows are the relations...
amitchandak
Super User
Super Userlukaszbrdon , do You need selection by name?
Your date join should not be active you will get a position for an employee in context using an independent date table
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return
calculate( max(Table[Postion]), filter('Table', 'Table'[Postion Start] <=_max&& 'Table'[Postion Date] >=_max))