Thanks! Yesss I was in the boat for a while where I couldn’t find anything that fully worked so when I finally figured it out I made this video, partially to remind myself how to do it when I need to, & of course to help others! It’s such a super common pattern that it shouldn’t be so hard!
Thanks so much! Glad you found it useful. I also spent a while on those videos and tutorials as I learned this process so I thought I'd compile the best solutions and redo one as simple as I could!
Ah my gosh this video saved me so much time - I have been pulling my hair out trying to work it out. One question, I work in recruitment and I used this formula to calculate open roles so I can work out number of roles per recruiter per quarter. Now I need to work out average roles per recruiter per quarter and I’m scratching my head again. Any advice?
Wow that is a great video, I will definitively save this for later use. This example can be elaborated on machine capacity or hotel occupation. This is a so common problem,, there should be a standard DAX formula for this.....do you know if there is a Quick Measure for this?
This actually works! I have looked at many solutions for the "Open Events over Time" type pattern on TH-cam and this is the first one i could use.
Thanks! Yesss I was in the boat for a while where I couldn’t find anything that fully worked so when I finally figured it out I made this video, partially to remind myself how to do it when I need to, & of course to help others! It’s such a super common pattern that it shouldn’t be so hard!
Great video and solution! This approach seems to be way faster than other solutions everyone else is showing here on youtube (at least for my chart).
Thanks so much! Glad you found it useful. I also spent a while on those videos and tutorials as I learned this process so I thought I'd compile the best solutions and redo one as simple as I could!
You just saved my life 🎉
Glad it helped! I had a consulting engagement that needed it & it took me so long to work out the method that I made this video so I wouldn’t forget!
Ah my gosh this video saved me so much time - I have been pulling my hair out trying to work it out.
One question, I work in recruitment and I used this formula to calculate open roles so I can work out number of roles per recruiter per quarter. Now I need to work out average roles per recruiter per quarter and I’m scratching my head again. Any advice?
I’m glad it helped, sorry but I can’t think of it, I’d need more context for that
Great work! I’m curious, which measure are you using for the line chart titled 'Workers Currently by Date'?
It should be the one I make in the video, let me know the timestamp if you’d like more info
Great video, Can I use the same formulas if I changed out the date (day) filter to a month-year filter?
I think you should be able to as long as you have a proper date table
Wow that is a great video, I will definitively save this for later use. This example can be elaborated on machine capacity or hotel occupation. This is a so common problem,, there should be a standard DAX formula for this.....do you know if there is a Quick Measure for this?
Yes! I couldn’t agree more. It should be easier than it is but at the moment there is no easier way to do it
Nicee video and topic. Thanks. Where's the download pls?
Thank you! Link is here: Https://www.xlconsulting-asia.com/youtube-files.html