This is a great explanation as always. One additional custom calculated column that I've added to our 4-4-5 calendar is called period offset. The beauty of this feature is that the current period is always 0 and is recalculated at every refresh. The offset of previous period is 1, period before that is 2, and so on. Future periods are -1, -2, etc. In this way you can create measures for previous period by simply identifying the period being filtered and add 1. If you need the previous 3, 6, 12 periods simply create a measure to set the selected visual filter period to VAR _selectedPeriod = SELECTEDVALUE() then filter >=_selectedPeriod + 1 &&
How can we calculate % utilization based on hours/efforts spend by a resource. Like when I want to calculate his/her weekly utilization, it should be /40. In case of monthly utilization, it should /40*4 likewise for quarter /40*4*3. Any sort of DAX we can create to keep the denominator dynamic?
Keep in mind that custom fiscal calendars are still built at the day level. So, creating a measure to calculate utilization (hours worked divided total hours planned/scoped) would still work. What you need to keep in mind is the initial filter context for the measure (week, month, quarter) as this will change how your utilization measure is aggregated.
This is a great explanation as always. One additional custom calculated column that I've added to our 4-4-5 calendar is called period offset. The beauty of this feature is that the current period is always 0 and is recalculated at every refresh. The offset of previous period is 1, period before that is 2, and so on. Future periods are -1, -2, etc. In this way you can create measures for previous period by simply identifying the period being filtered and add 1. If you need the previous 3, 6, 12 periods simply create a measure to set the selected visual filter period to VAR _selectedPeriod = SELECTEDVALUE() then filter >=_selectedPeriod + 1 &&
Have been looking everywhere for this fix! Thank you. Do you have one for QTD or YTD?
This is brilliant. Do you have a video with the same logic but applied to Fiscal QTD ?
Outstanding Aaron, thank you!
Thanks Fred!
Just what I was looking for, thanks!!
Happy to hear it!
Absolutely brilliant
Thanks Saraswathi!
This is amazing! Is there available to download the PBI file?
Hi, I would like to know how much time do I have to take the exam PL-300 after making the purchase? Are we talking about 2 weeks? Thank you :)
New Content. Love it. 😊
Thank you Bolaji!
great video, made me to subscribe your channel ;)
How can we calculate % utilization based on hours/efforts spend by a resource. Like when I want to calculate his/her weekly utilization, it should be /40. In case of monthly utilization, it should /40*4 likewise for quarter /40*4*3.
Any sort of DAX we can create to keep the denominator dynamic?
Keep in mind that custom fiscal calendars are still built at the day level. So, creating a measure to calculate utilization (hours worked divided total hours planned/scoped) would still work. What you need to keep in mind is the initial filter context for the measure (week, month, quarter) as this will change how your utilization measure is aggregated.