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

[@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!

[@Sunsets_LoFi]

Really cool and detailed explanation))🔥🔥🔥

[@johnabram4159]

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

[@PragmaticWorks]

Glad to hear it!

[@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.

[@qwerty4964]

Nice explanation!!

[@aditisharma7221]

LOVED IT !

[@cesarsaldana3429]

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

[@PragmaticWorks]

Thank you for watching!

[@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 ! :)

[@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?

[@stoutis_tavern4203]

I learned a lot, thank you very much :)

[@PragmaticWorks]

Glad it was helpful!

[@tubeitz]

Excellent

[@PragmaticWorks]

Glad you enjoyed!

[@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. :-)

[@sureshchawla7370]

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

[@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

[@emilyamalkin4367]

Why is date table needed for rolling averages?

[@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)

[@arunv1909]

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

[@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

[@Ilya_4276]

thanks

[@PragmaticWorks]

You're welcome!

[@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?

[@sasikr]

❤