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!

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 !

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

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

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

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

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.

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.

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

You are the best DAX explainer BY FAR!

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

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.

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

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

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

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

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

Superb feature and Thanks bass u explained amazingly ...

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

Great to have you back my brother

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.

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

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

Very well explained, congrats!

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

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

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.

Thanks for the great content !!

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

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?

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.

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

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

Congrats on the 100.000 subscribers!! :-)

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

Lovely explanation thank you mate 👏🏻👏🏻

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

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

Congratulations on the 100k subscribers - thoroughly well deserved

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

Great work Bas, thank you!

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

this try & error Tempo so good!

Like the way how you explain new functions!

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

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

You are a great teacher! This has been really helpful

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.

Thank you for sharing!..

double kudoz Baz, superb one

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

Thank you for one more beautiful presentation.

Brilliant video. Thank you so much!

Thanks Bas

Great examples!

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

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.

Lovely! Thanks so much.

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

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 =)

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

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

Thank you

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

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

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.

Excellent!

No Brazil temos alguns canais mto bacanas tbm sobre o tema

Brilliant!!!

Nicely Explained...Thanks☺

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

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

amazing content!

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.😊

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?

Brilliant.... in short

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

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.

Thanks!

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

Professor of year: Bas.

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

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

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

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

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! 😝

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

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

Please show some applications of INDEX() function.

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?

I used to wrtie a measure of 7-day running average, but now I can use window function. maybe next time I can ask chatgpt to write for me.

DAX GURU!!!

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?

Is there any alternate functions available for Window function ?

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?

why did we do summarize by?

Hey Bas , long time no videos ... Would love to see something on HTML custom visual to bring in some design ideas.

Grazie

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

Awesome!!!