topic Re: DAX Filtering in DAX Commands and Tips

DAX Filtering

rivo201 — Tue, 17 Mar 2020 13:16:27 GMT

Hi All

EDIT: (changed question format)

I have two tables:

Employee information on what position he worked at period of time.

EmployeeID	Position	ValidFrom	ValidTo
1	Engineer	01/01/2014	01/12/2016
1	Manager	01/12/2016	31/12/2154

Employee workhours table by dates

EmployeeID	Hours	Date
1	10	01/02/2014
1	10	02/02/2014
1	10	03/02/2014
1	10	07/02/2014
1	10	08/02/2014
1	10	08/02/2018
1	10	09/02/2018
1	10	10/02/2018
1	10	15/02/2018
1	10	16/02/2018

How can i get the correct or current time employee postion to workhours table?

I know i have to check : IS Workhours.Date between ValidFrom and ValidTo ,If TRUE -> Get me Postion value

How to put it in DAX. Thank you.

Re: DAX Filtering

Greg_Deckler — Tue, 17 Mar 2020 12:39:42 GMT

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: DAX Filtering

rivo201 — Thu, 19 Mar 2020 12:32:19 GMT

For me the topic is not finished for finding solution with DAX - but for now I solved the problem using SQL.

Thanks..