WINDOW Function in ACTION I Examples in Power BI

[@JustRandomExplorer]

Great! to be honest every single of your videos are someway or another valuable. One of the best Power BI content creators on youtube. Thanks again!

[@HowtoPowerBI]

So nice to hear! Thanks a lot 😊

[@hainsay]

Massive agree. I watch SQLBI for the minutiae of detail of DAX and how it works, the most technical stuff from first principles, and I watch Bas for exposure to report components I wouldn't otherwise know about, and how to bring the whole thing together. I don't think I'd know anywhere near as much without both.

[@habuiah]

@@hainsay Oh yeah! The combo SQLBI + HTPBI is the gold content on KZbin!

[@kebincui]

The best DAX and Power BI content presentor 👍👍👍👍👍👍🌹🌹🌹🌹🌹🌹

[@baskis69]

Thank you very much for sharing. You explain in a masterful way¡¡¡¡

[@KyleCroucher]

You are the best DAX explainer BY FAR!

[@GladiusArch08]

I watched it at the time and remembered it. Sure enough finally had to use it in one my reports. Thanks a ton! You're a life saver

[@IonbeamGreg]

I really appreciate how you explain DAX. Detailed, explaining what is is important and where could be our mistakes. A step by step visual explanation. thanks !

[@ekaterinavolkova4348]

The best video I've ever seen about the window function in Power BI. And I really like your way of telling it-smooth, positive, without unnecessary excitement.

[@SamE-kq5in]

Thanks!

[@HowtoPowerBI]

thx for thesupport!

[@mwaltercpa]

I love how your videos address technical DAX with a practical business case approach.

[@21121990jay]

Precise and unambiguous explanation. I'm sure even chatGPT wouldn't be able to explain this easily.

[@PowerBi_ExcelDashboards]

Great to have you back my brother

[@Abiah]

18:57 Wow! This is great. Thanks for sharing 🎉

[@lubomirjagersky7327]

Thank you

[@HowtoPowerBI]

thanks a lot for the support!

[@AgustinFernandez1009]

Your videos have helped me a lot, I notice how I started using PowerBI in a whole different level since I suscribed

[@ayoubaitelkadi7796]

You deserve +10 M subscribers and not +100K. Your enlightenment is greatly appreciated!!

[@kostaszogo21]

Give that man a daily show in a national broadcasting channel!!! once again Bas delivers 👏

[@HowtoPowerBI]

maybe one day... :)

[@stevenhampson8657]

Brillian Bas back again (from a real human). Really, really value your content - friendly approach, quality, detail, right level and the backing of the website with extra information and reference files.

[@HowtoPowerBI]

Thanks a lot for those kind words! 😊 made my day

[@akshay1darve285]

Superb feature and Thanks bass u explained amazingly ...

[@carlwagner3838]

Thanks for the tutorial. I am very happy to see the Window function for creating moving averages over tables that have no dates. Wrote my first last night after upgrading to the Dec PowerBi desktop.

[@marcelolopes5684]

Very well explained, congrats!

[@mathiassaint]

Thanks for yet another great video! I especially love that u display the end result in the start of the videos! :)

[@pabloalonso4017]

This is by far the best PBI channel. Congrats and thank you for all the unique knowledge you have shared.

[@nseworld5521]

Like the way how you explain new functions!

[@estebansuarezcastro7053]

Bas, this video is going to save my job this week. Excellent work!

[@awarrentfa]

This was an excellently crafted lesson, with each aspect of the formula demonstrated precisely when it would be necessary and useful. Well done!

[@HowtoPowerBI]

Glad you enjoyed it!

[@J0n0nI]

Appreciate your videos content. I am really learning a lot from them. as your explanation to the functions and the visualizations made them so easy to follow. Thank you.

[@Cpl82111]

Congrats on the 100.000 subscribers!! :-)

[@pepper_lab]

Brilliant!!!

[@scobob]

This is fantastic. I already have a bunch of use cases in mind for this. Thanks for the clear explanation!

[@victorsalaspsalas3119]

You are great, thank you very much for your teachings, I am from Chile and a faithful follower.

[@HowtoPowerBI]

Wonderful! Thank you for watching Victor!

[@РинатХабибрахманов-ш1й]

it's great that you're back, otherwise I started to think that the previous video is really the last one😁

[@lmsweed]

😂😭

[@HowtoPowerBI]

No worries, planning to stick around for a little longer :)

[@РинатХабибрахманов-ш1й]

@@HowtoPowerBI very good, your channel is the best

[@MVoss-nr6sd]

Yes ! Bas is back I agree @how to power BI channel is the best Thank you Bas

[@relogbr]

Great work Bas, thank you!

[@sebastienschoonjans9727]

Thanks for the great content !!

[@flyeagle320]

BAS it was very informative . Need time to understand . Thanks for the video :)

[@earlnoli]

Lovely explanation thank you mate 👏🏻👏🏻

[@josefedericopresno6668]

Great to see You again, Bas! Awesome video as always. Thanks for share your PBi knowledge

[@EricaDyson]

Lovely! Thanks so much.

[@atanasprodatanasov9233]

Brilliant video. Thank you so much!

[@LeighRadmore]

Congratulations on the 100k subscribers - thoroughly well deserved

[@HowtoPowerBI]

Thank you very much!

[@sukoi2113]

Thank you for one more beautiful presentation.

[@HowtoPowerBI]

Very nice to see a comment from you in the new year!! Hope you had a good start

[@Amr-Ibrahim-AI]

Thank you so much Bas for your detailed video 👌🤝👏👏👏

[@lguzjim]

Excellent!

[@jamesshi9993]

Super good, well explained and easy to understand. Thanks!

[@ezekiel0606]

amazing content!

[@barttrudeau9237]

You are a great teacher! This has been really helpful

[@HowtoPowerBI]

Glad it was helpful! 😊thank you

[@premcst]

Spot on !! And Congratulations on 100K subs .. More to go ..

[@HowtoPowerBI]

Thank you very much!

[@___________mrivan___________]

All the other approaches using DATESINPERIOD and DATESBETWEEN have failed for me. This is the only one that worked perfectly. Thank you!

[@VesBuk28]

Great examples!

[@sherifffruitfly]

This is a very good video. Showing the need for the params by seeing what goes wrong is super helpful. Also taking it end to end with visualization is nice. Video would be enhanced by adding discussion of what the code IS doing in the "wrong" versions. I.e. the code isn't doing anything wrong - it's doing exactly what you told it to do. Understanding what you're telling PBI to do is the fullest learning. Performance vs old ways to do the same could also be discussed.

[@fraggle200]

@ 12:18 when you point over your shoulder, there's no visualisation on screen.

[@udusegbe]

Awesome Function! And even more important, thanks once again for a very clear explanation video :-)

[@joaorataoo]

Excellent presentation! I hope that that peregrine idea that IA would replace you is now forgotten. ChatGPT is very interesting as a support, to break a block, not to learn how to know how to do it. This is just my opinion, of course! Keep going and thanks!!!!!!!!!!!

[@RubenCarlosCalderonValladares]

Really nice! Window Function is Flexible and easier to code!

[@nehikmetse]

Bas you are a gem, really good explanations and kick ass hidden tips and tricks. Really valuable presentation.

[@Lunatic244]

Sir your voices are great I learn everything from your channel. Sir can you make tableau video?.

[@lubomirjagersky7327]

Wow! Thanks a lot for your effort. Your videos are awesome, I like your energy that you put into an explanation. I don´t need to speed up your video as many others... You create amazing content, I´m always looking forward for your next video...Really great work

[@soumyadeeppattanaik526]

Nicely Explained...Thanks☺

[@changeyourmind-p1n]

Around 9:11 you talk about if we want the first 2 months to be blank. I saw it over and over, but could you please show the DAX formula for it? Ty =)

[@就已]

this try & error Tempo so good!

[@vram11]

Brilliant.... in short

[@Saif_Ali_Khan_1301]

Brother how do you edit your videos, can you make a video on this topic, you editing is as awesome as your content

[@unnikrishnansanthosh]

double kudoz Baz, superb one

[@jidi10]

Getting a "The expression refers to multiple columns" error for the Summarize function. Tried switching away from Dax date table but still has error, any ideas?

[@3danim8r1]

Thank you for sharing!..

[@HowtoPowerBI]

😊😎

[@richardmartin7904]

Awesome. I would love to see you get messy with more windows functions. Does this mean there is even wilder dax and dynamic calculations we can do? Will there be a theoretical argument for using DAX window over sql window? Which one is more efficient?

[@valentinaverissimo5584]

No Brazil temos alguns canais mto bacanas tbm sobre o tema

[@thebookyogi]

Awesome explanation... Would appreciate if you make a video on exponential weighted moving average ..

[@mabenba]

Amazing video!! Thanks for sharing your wisdom with us. I can't the same result as the second option replacing the quarters by the months. I need to upskill my DAX.

[@storybi4636]

I'm very interested to learn how the new functions and performance stack up against existing ways to write DAX. i.e. custom time with CALCULATE and Filter/All/Time. As someone looking at learning and adoption, it seems like the new functions are just as involved as the old CALCULATE with modifiers. Thanks again, I really enjoy your videos.

[@barte894]

Hi. I have some question. I need to make slicer panel with percentage intervals. Example: 30% Is it posaible to do that in power Bi?

[@pepper_lab]

Yes why not

[@barte894]

@@pepper_lab but how? ;)

[@MVoss-nr6sd]

Bas I have a question how do you deal with the dax function Count and Distinct count if you have to count people

[@danielslagter]

after you added the Avg line Q3 and Q4 has added to the visual even though they are empty, is there a way to hide that? to see only quarters with values

[@davidtanchon3067]

Hi, I would like to use this function, but it's not reconized by Power bi desktop (version Dec 2022)

[@antique-bs8bb]

Really nice vid and I really learnt a lot. Love the deliberate teaching mistakes Just one bitty query. For a 3 month Moving average we used From -2, To 0. (time 3.30) For an n-month Moving average we used From -n, To 0. (time 11.20) where n is your [NR Months Value] parameter. So I reckon we are producing an n+1 moving average. Easily fixed mind.

[@therainman8703]

Thanks for your help and appreciate you for helping others. I have my devices data in adls gen2 in folders & sub folders . I have made a dashboard for one device by using the data source as adlsendpoint/one device .. how can I provide an option in power bi report, like user can select device id from drop down which automatically changes the data source path adlsendpoint/newdeviceid and refreshes charts One device - one dashboard charts Need option to select new device from report (new device is a new folder in adls ,) is this possible ...please help

[@justlearnitquick]

How can we calculate rolling average if windows function was not available in pbi dax ?

[@HowtoPowerBI]

here you find an example www.sqlbi.com/articles/rolling-12-months-average-in-dax/

[@manjunatharalikatti2202]

Nice explanation .. Please explain, scenario 1. If we are on Jan 23, I want to start calculate moving avg from DEC-22, i.e always start moving avg from last month (Jan data should not be shown in report ) Present date Today()-1 from measure or in window function not working..

[@sebastienschoonjans9727]

Is there any of you folks which could tell me how i could do this by Item Reference per Date? i do not see how to add my Items with the Calendar Date and ALLselected function

[@natsarev]

Didn't quite understood why is it better then calculate + filter? Is it faster or..?

[@HowtoPowerBI]

seems to be faster (still have to do some checks for myself) .. and I believe it is an attempt to make dax easier (I think more functions will follow)

[@jonahjohnbaba]

Please the line chart can you do a video that you use a target to say if you achieve the target the bar is green and if not is red and then the target should recalibrate itself based on the gap yet-to be achieved. Thank you

[@allmazd]

Thank you Bas for the explanation, it is pretty good as always! I have a question, what was the purpose to add the column month in the relation clause if it is also monthNO column in there and the column month has not been used in anywhere else?

[@juliom6260]

Thanks Bas

[@spilledgraphics]

Professor of year: Bas.

[@HowtoPowerBI]

🤓😄 thanks!

[@martingoedhart2294]

Have yet to experiment with the Windows functions, but I'm afraid that while the intent is to make things easier, it can work confusing to introduce an alternative approach that works different from regular DAX theory. I wonder if they are slowly converting the language in a way that Windows functions become the standard approach or if there will always be multiple methods. The code for moving average is not easier at all compared to a simple; VAR LastDate = MAX(Dates[Date] RETURN CALCULATE([Measure], DATESINPERIOD(Dates[Date], LastDate, -3, MONTH) I'm sure though that there are some benefits that would require few lines of Window function compared to pages of DAX though. Curious to discover them.

[@hussamamal]

Awesome video, Bas! Inspiring to see your vids, really. Question: How to use the MA measure to show expected total sales for next month, and then include that forecast in the next next month? You know, as in excel where it's a really simple cell-reference, I've found it quite tricky in DAX.

[@magnolita999]

Would you know how to design a report where you see "best man for the job" based on how much experience they had working on projects in the past? You would select various categories or subcategories of projects that would "spit out" the best man for the job?

[@valentinaverissimo5584]

Olá seus vídeos estão sendo mto bacana para o meu desenvolvimento...compartilha a sua paleta de cores...pls

[@PSAndPowerBI]

if bus publish a powerbi book, i'll buy it .for bas is best video series of PowerBI

[@vijayvizzu1]

Is there any alternate functions available for Window function ?

[@mcdonaldikisielmeow]

DAX GURU!!!

[@Tyraelxadrias]

We awesome video!

[@OlugbemiAkarigbo]

Awesome!!!

[@464jam]

Hi, Nice video once again. Can you make a video to make "Skyline Chart" in Power bi , currently there is no custom visual to make such chart but i believe you can crack and we all learn from you. Thanks.😊

[@switchfire]

Awesome video! Do you think the Window function is the best way to calculate moving averages? Is it possible to use these averages to 'predict' future values of dates? If I don't have values for future dates in my dataset, could I create them with a measure and incorporate those averages? Sorry for so many questions! 😝

[@gokulmurali4481]

Can we find growth rate using the windows functions?

[@HowtoPowerBI]

you can use the window function to for example return the value of previous month and then divide current value by that -1

[@gokulmurali4481]

@@HowtoPowerBI in future can u make a video regarding that

[@121balu]

How do we get max value by using window dax

[@danishjameel6014]

why did we do summarize by?

[@HowtoPowerBI]

summarizeby creates a summary table from dimdate (year, month, monthr) .. that flows into the window function which needs a table expression from which the output row is returned.

[@changeyourmind-p1n]

Hey, if possible, please make a video on how to calculate the moving average of last X days where it only calculates days that had transactions. Example: there were transactions in the month of january on days 10, 13, 17, 23. The moving average should only start appearing on the 23rd and should be sales (or whatever measure) of those 4 days divided by 4. Thx in advance

[@jiawang1257]

Thanks!

[@HowtoPowerBI]

Thank you for supporting the channel!