Power BI DAX: Time Intelligence Rolling Measures (Tutorial) 💥

In this video, learn how to use built-in DAX Time Intelligence functions to report measures over a continuous rolling period of time. In this video, you will see how to report a value that is being summed for the last 3 months. Meaning when we look at the value for March 2021 we will see the sum of the values from January 2021 through March 2021. This measure works at all levels of time, thus if we are viewing data for December 29, 2021, we would see the sum of the values from September 30 2021 through December 29, 2021.
I will explain every part of the function and how it is working as I build this measure out.
If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing our On-Demand Learning classes from pragmaticworks...
#MatthewPeterson #PragmaticWorks
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing our On-Demand Learning classes to get extra 20% off - pragmaticworks...
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning Courses Free Trial: www.pragmaticw...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RUclips: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]

[@rauljimenez5485]

I like the use of NEXTDAY and LASTDAY to get the start/end dates, will come in handy

[@Dansel_B]

Thank you so much Matthew, your videos on DAX are of precious help to me. please keep it up!

[@elleeaton1951]

Thank you so much, this is the first video of yours I have seen and it has proved to be very useful! Subscribed!!

[@PragmaticWorks]

Thank you for watching and subscribing! Glad you enjoyed.

[@johnabram4159]

Great explanation @ 10:50. That lighted a bulb in my mind!

[@PragmaticWorks]

Glad to hear it!

[@qwerty4964]

Nice explanation!!

[@aditisharma7221]

LOVED IT !

[@Sunsets_music]

Really cool and detailed explanation))🔥🔥🔥

[@Freemachains]

Houff I finally found some interesting stuff about time intelligence, all the others are same mtd, ytd I mean basic things. This one is genius! I'll subscribe and hope to have more advanced time intelligence videos 👍🏻👍🏻👍🏻

[@PragmaticWorks]

Glad you enjoyed!

[@Freemachains]

@@PragmaticWorks don't forget, more time intelligence Please ! :)

[@cesarsaldana3429]

Amazing!!!!......... Gretings Froms Mexico.

[@PragmaticWorks]

Thank you for watching!

[@stoutis_tavern4203]

I learned a lot, thank you very much :)

[@PragmaticWorks]

Glad it was helpful!

[@Varun.Khanna1602]

Excellent

[@PragmaticWorks]

Glad you enjoyed!

[@chakrabmonoj]

Hi - this is a great lesson again! I had a question though:
if we needed to get a moving average for say, the same 3 months or 3 days, would we need to replace the "CALCULATE" with Average or AverageX?

[@Ilya_4276]

thanks

[@PragmaticWorks]

You're welcome!

[@JanaDVORAKOVA-s8m]

Hallo, thank you for this video. I woud be interested in seeing a video on rolling YTDs-1 and MTD-1 for a open month. For example, when I update my sales report on weekly bases. I can see the YTD data for the period 1.1.24-15.5.2024 by using TotalYTD DAX function, but for the previous month, it shows me only the total May 2023. How to do it, so that I would see comparable rolling period. Thank you. :-)

[@eugenekim4523]

How do we deal with a scenario where the data starts other than the beginning of the month (i.e. in the middle of the month or somewhere else within that month)

[@emilyamalkin4367]

Why is date table needed for rolling averages?

[@patrickkinbonso1809]

Hi, thanks for the video. Can I please ask . how we can allow users to choose how many months or weeks to roll back please?
Rather than that I have to manually change the roll back period, can that roll back period (in your example" is 3 months .. if someone want to roll back 2 months only .. is there a way they can choose on the dashboard, then the data will update from 3 months rolling to 2 months rolling? Thanks

[@arunv1909]

my confusion is without doing variables, directly adding dateadd, also gives the same though

[@sureshchawla7370]

Can you tell me how to calculate YTD from April to March excluding January Month Sales figure ??

[@idolsensei7]

I need to do this rolling months using bar and a line graph but my dates are not per day its only the month. What I need to show are the Inflow, Outflow of the countries in my list. So once I filter a certain country, the 12 months roll data of that country will show in a bar and line graph. What would be the best measure for that?

[@realchattv4389]

Could I use this to do a unique customer count in the last 24 months
Considering I have monthly customers via a subscription and get new people every month

[@sasikr]

❤