Events in Progress

[Greg]

Related Content:

Below are a few examples of issues related to the Events in Progress DAX Pattern from the eDNA resources.

Enterprise DNA Forum (Search):

Working with two dates - show amounts between two selected dates

Ok I think I understand a bit better. What is required here is a derivative of this technique showcased in the ‘Solving Analytical Scenario’ course at Enterprise DNA Online. It’s called the ‘events in progress’ pattern You definitely want a date table, but you need to have two ‘inactive relationships’ down to the fact table. Run through this example, and set up your model this way, then let’s work on the formula if you can’t work it out from here

How to calculate multiple rows for a condition

I understand this can be confusing and quite a lot of people get caught on this. It’s all about dealing with multiple dates in your fact table, like you are here with the workflow process. The key here is a two-step process. First, you need to get the data model correct then, use the right DAX measure. It’s not too difficult once you know the technique here. The technique is detailed here. It’s not the exact scenario you have but the technique of dealing with multiple dates is exactly the sam…

Allocating Order Units by Start and End Dates

Here’s exactly what you need for this. It’s called the ‘events in progress’ pattern. It’s very important to get the model and relationship set up correctly for this, as well as the DAX measures. Everything is explained in the video. Should solve it. Chrs

In-Transit Date?

What you need to use here to the ‘events in progress’ pattern or technique. This will give you the amount which is considered in transit on a specific date. Check out the tutorial here which covers this technique in a bit of detail You need to solve this in the model with slightly different relationships (inactive ones) then a specific formula technique that works with these unique relationships. This should get you what you need I believe. See how you go Sam

Employee Headcount

Sure happy to look into this but need to know more. There’s a lot at play here so need to understand the data within the tables, how you setup your data model including the relationships you have and also what is the current context of the calculation. Unfortunately with DAX it’s never a simple as just reviewing the formula by itself, there always more to it. If you want to add a demo model here with the scenario then that will speed up assistance. Chrs Just as a side note on this as well a…

Enterprise DNA TV (YouTube):

Total Number Of Staff Over Time

Total Number Of Staff Over Time - Power BI Insights

How To Manage Multiple Date Calculations In Your Fact Tables - Advanced Power BI

How To Manage Multiple Date Calculations In Your Fact Tables - Advanced Power BI