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 beetwen tables.
I am not able to connect with active reliation Date and employees table. It has to be at that shape.
1 Reply
- amitchandak
Super User
lukaszbrdon , 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))
