DAX Fridays
Vložit
- čas přidán 16. 01. 2023
- 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 ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
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!
Thanks 😊!
Thanks for bringing us the news!
This came just in time for a new activity scoreboard project. Looking forward to checking it out in a bit!
More to come on the topic very soon :)
Excellent introduction to Window functions!
Thanks!
great as usual
Thank you so much!!
Very good!
Could be useful in several situations. Thanks.
Indeed! We will explore further in upcoming videos :)
Bra förklaringar Ruth. God fortsättning. Jag har testat alla tre huvudfunktionerna.
Samma Thomas!
Du son kan SQL vad tyckte du av dax Window functions?
@@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.
Tror samma :)
Awesome ❤
Excellent video
Thanks 😊
Thanks a lot. Looking forward the details video
Continue with them next week :)
Woow! Thanks 🙌
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
Thank you verry verry much !!!!!!
😃
Thanks for the video
How is it different from all,allexcept,removefilters,keepfilters?
Here you have all the details :
pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/
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?
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
Yeah, I am also confused by this functionality.
The parameter ABS sets the order for DAX, we will explore this in detail on the WiNDOW video coming up
The parameter ABS sets the order for DAX, we will explore this in detail on the WiNDOW video coming up
I see a lot of the Dax Friday PBIX files (in the download centre) are not available....this one being one of them
Hi, sorting column affect results?
I am still learning this functions, but my guess is yes. Will see once I deep dive on it :)
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.
The power bi community is the perfect place for that type of support. Try it!
in the function part order by can't use measure or virtual table column?
Will do a deep dive on window soon
hardly laughed during the video. that's rare. hahaha
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
Ruth please tell us about your family.
Kids pictures please
Thanks for wanting to know more about me, but my family prefers to stay private.
Enjoy the weekend!