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
- DAX measure with start AND end date for Power BI ( Download)
- DAX and the Start Date End Date Problem aka Events In Progress ( Download)
- DAX for Power BI - Week Start Date & Week End Date ( Download)
- Abstract Thesis 95: Power BI- DAX: Get all dates between the Start and End date ( Download)
- STARTOFMONTH, STARTOFQUARTER, STARTOFYEAR, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR - DAX Guide ( Download)
- Calculate the Time between Two Dates in Microsoft Power BI (Days, Months, Years) | DATEDIFF DAX ( Download)
- Generate dates between Start Date and End Date in Power BI ( Download)
- Return Working Days in Power BI using DAX ( Download)
- 📊 How to use Power BI DAX - Tutorial ( Download)
- Use Duration.Days and LocalNow() for # Days until/since a Date in Power BI using Power Query Editor ( Download)
- Generate Dates between Start and End Date in Power Query ( Download)
- Calculate Average Per Day / Month / Year In Power BI Using DAX ( Download)
- Get Max Date for a Particular Category/Group using Measure in PowerBi | MiTutorials ( Download)
- How to find the last day of month using DAX Power BI ( Download)
- Subscription Pattern in Power BI DAX Measure for Active Subscribers or Open Tickets For All Dates ( Download)
