DAX measure with start AND end date for Power BI

Power BI can only handle one active relationship between two tables at one time, but you can work around this limitation with DAX, allowing you to get a measure dependent on a start & end date using DAX (and not using Power BI's relationships).

Some common examples include number of staff, students, customers or quantity on stock that can be filtered for any date. In each case people/stock has a start & end date (or maybe no end date if they are still there), and its common to want to look at this based on date filters, e.g. how many staff did I have on 3 May etc. You need a few combinations to make the DAX work, and I go through that in my new video.


00:00 - Introduction
03:25 - Headcount
04:17 - Activate relationship
05:23 - Started on or before date
08:16 - End on or after
09:52 - What if people didn't t leave
10:36 - Left after or didn't leave
12:28 - Current
14:32 - Headcount currently or not left