Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm trying to calculate the status of certain records on a day-by-day basis between 2 dates (Opened and Closed). I also have a 3rd date column which helps us determining the actual status of a record. Here is the logic I'd like to apply:
- if close date > Expeceted close date --> the status should be Delayed
- if close date <= Expeceted close date --> the status should be On Time
I'd like to end up with a graph (e.g.: linechart) where the X axis is Date and on the Y axis we can see the the sum of On Time and Delayed records separately over time. I recon I could create a new table with each day in it for each ID and calculate the actual status of that day on said ID, but I was looking for another solution, like 2 measures similar to this:
Number_of_OnTime =
CALCULATE(
Here is the link of the example file.
Thanks in advance!
Solved! Go to Solution.
@DPatkos , You can use the Active employee method of HR to plot open. And then you can check for date for delayed
Yet to check the file
@DPatkos , You can use the Active employee method of HR to plot open. And then you can check for date for delayed
Yet to check the file
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |