DAX Fridays

Window functions performs calculations in different groups of rows. Let me show you how and why this is powerful for DAX and Power BI:
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@churtado1984]

You are the best in the world, thanks to you I was able to solve a problem I had with a measure that did not work and now I do not miss a single one of your videos. Thanks for sharing your knowledge!

[@CurbalEN]

Thanks 😊!

[@IvanCortinas_ES]

Thanks for bringing us the news!

[@Kfox0963]

This came just in time for a new activity scoreboard project. Looking forward to checking it out in a bit!

[@CurbalEN]

More to come on the topic very soon :)

[@RubenCarlosCalderonValladares]

Excellent introduction to Window functions!

[@CurbalEN]

Thanks!

[@fuberlin1]

Thank you so much!!

[@walidkhlil2872]

great as usual

[@joangarcia6327]

Could be useful in several situations. Thanks.

[@CurbalEN]

Indeed! We will explore further in upcoming videos :)

[@datareggibi]

Very good!

[@nachomiranda5151]

Thanks a lot. Looking forward the details video

[@CurbalEN]

Continue with them next week :)

[@fabiosmstel]

Woow! Thanks 🙌

[@numberkruncher5237]

Excellent video

[@CurbalEN]

Thanks 😊

[@nazmulhaque3894]

Awesome ❤

[@xavier_le_x]

Thank you verry verry much !!!!!!

[@CurbalEN]

😃

[@thomasivarsson1291]

Bra förklaringar Ruth. God fortsättning. Jag har testat alla tre huvudfunktionerna.

[@CurbalEN]

Samma Thomas! Du son kan SQL vad tyckte du av dax Window functions?

[@thomasivarsson1291]

@@CurbalEN Mycket användbara. Har funnits i TSQL länge(2012). Kommer att förenkla DAX när vi skall göra beräkningar som passerar radkontext. Mindre komplex DAX tror jag.

[@CurbalEN]

Tror samma :)

[@AnikulapoOlawale]

Thank you so much for the video, but I noticed that when you changed the starting position to 1, the personnel and sales values also changed. I thought changing the starting position should not affect the personnel and the sales values

[@arahan599]

Thanks for the video How is it different from all,allexcept,removefilters,keepfilters?

[@CurbalEN]

Here you have all the details : pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/

[@fernalication]

Is there any way to get only the previous or following record on a table? Not a measure, not a calculated value just bring the row value?

[@charlesdelanoy]

I see a lot of the Dax Friday PBIX files (in the download centre) are not available....this one being one of them

[@sarajvo2010]

Hi, sorting column affect results?

[@CurbalEN]

I am still learning this functions, but my guess is yes. Will see once I deep dive on it :)

[@user-of8df9vy3d]

in the function part order by can't use measure or virtual table column?

[@CurbalEN]

Will do a deep dive on window soon

[@HarshNathani]

Nice video as usual. However, when we use the value 2 to start from , how does DAX understand whether it should exclude the highest value or the lowest value from salary column for developers

[@Kfox0963]

Yeah, I am also confused by this functionality.

[@CurbalEN]

The parameter ABS sets the order for DAX, we will explore this in detail on the WiNDOW video coming up

[@CurbalEN]

The parameter ABS sets the order for DAX, we will explore this in detail on the WiNDOW video coming up

[@waveekewl27]

hi, a noobe, hust gone through almost all video at a glance, i have a query regard to power bi , importing csv files(large ones) and working on sample file, ;like, 1) converting it to pivot, so that all other files should join in pivot only and then , 2) i need to get two section say one is sales and one is purchase and 3) both should give me five top and five bottom ...how I should go about it..if any other solution , i will appreciate.

[@CurbalEN]

The power bi community is the perfect place for that type of support. Try it!

[@Truth-N-Lies]

Ma'amm, I'm Unable to calculate moving/running average using Average Cost moving = AVERAGEX( WINDOW( 1,ABS, 0,REL, SUMMARIZE(ALLSELECTED('Custom Calendar Table'), 'Custom Calendar Table'[FY], 'Custom Calendar Table'[Month Name]), ORDERBY('Custom Calendar Table'[FY], ASC, 'Custom Calendar Table'[Month Name], ASC)), [Actual Cost] ) Results is Average Cost moving Actual Cost Month Name FY 220599.2747 220599.2747 Dec FY 22-23 219440.6214 219440.6214 Jan FY 22-23 216470.4219 216470.4219 Feb FY 22-23

[@chengwang411]

hardly laughed during the video. that's rare. hahaha

[@premjitchowdhury262]

Ruth please tell us about your family. Kids pictures please

[@CurbalEN]

Thanks for wanting to know more about me, but my family prefers to stay private. Enjoy the weekend!