Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I tried searching around trying to figure out how to calculate a rolling 4 quarter total of units, being based on the fiscal year. I want the rolling 4 quarters to include the current quarter and then the previous 3 quarters. I have a Calendar dimension table that I added in columns to determine my fiscal year and quarter. Below is the current measure that I'm using that I found in a tutorial - while it has no errors, it also doesn't give me any results.
Solved! Go to Solution.
@aharris15 it is good you have a calendar dimension but you need to mark it as a date table, check my videos on times intelligence and then your measure will work, assuming start day and end day are getting calculated correctly. Learn basics of Time Intelligence DAX functions - Part 1 - YouTube
Rolling 4 Qtr Unit Total =
var StartDay = NEXTDAY(LASTDATE(DATEADD('Calendar'[Date],-4,QUARTER)))
var EndDay = LASTDATE('Calendar'[Date])
return
CALCULATE([Total Units],DATESBETWEEN('Calendar'[Date],StartDay,EndDay))
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@aharris15 good to hear it is working, although it looks like a small/simple step it is super CRITICAL
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@aharris15 it is good you have a calendar dimension but you need to mark it as a date table, check my videos on times intelligence and then your measure will work, assuming start day and end day are getting calculated correctly. Learn basics of Time Intelligence DAX functions - Part 1 - YouTube
Rolling 4 Qtr Unit Total =
var StartDay = NEXTDAY(LASTDATE(DATEADD('Calendar'[Date],-4,QUARTER)))
var EndDay = LASTDATE('Calendar'[Date])
return
CALCULATE([Total Units],DATESBETWEEN('Calendar'[Date],StartDay,EndDay))
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Oh wow, that seemed to work! Thank you - can't believe I missed that little step!
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |