Window functions are awesome! One tip though, you missed an opportunity to explain some new t-sql stuff ;) Since sql server 2022/azure sql, there is the new window clause. Which enables you to specify a window once and reuse it many times. When you use window functions extensively you will often see the over() part being copied many times within one statement. The window clause allows you to deduplicate your code. Would have been a nice addition for the folks already familiar with window functions.
Great video Patrik ;) Do you know if the OVER statement can generated in power query through the query folding? Or will it be in a near future ? Maybe a question for the master Alex Power?
Love theese videos, but can you put and show us how you put what you write in a view or table and import it to powerbi. I know it sounds stupid but alot more people with catch on and it will bedome a smooth transition from a-b.
Just wondering if what you ve done here cant be done faster in power query in native query mode then copy paste bam, or copy paste to chat gpt to shorten/ check and bam done, aint this way a dinosour way :) ? I know not all can be done by nq but a lot
This video deserves more likes than it's getting! I'm in an internship where I'm using T-SQL and PowerBI, and these videos are very VERY helpful!
I love the T-SQL videos. Explained in an easy, concise way.
Thanks Joe. We will keep them coming.
Since I learned T-SQL before doing DAX, I use windowing functions all the time! SUPER handy!
wow , that's so nice Patrick
Love the T-SQL journey!
Window functions are awesome! One tip though, you missed an opportunity to explain some new t-sql stuff ;) Since sql server 2022/azure sql, there is the new window clause. Which enables you to specify a window once and reuse it many times. When you use window functions extensively you will often see the over() part being copied many times within one statement. The window clause allows you to deduplicate your code. Would have been a nice addition for the folks already familiar with window functions.
Nicee! Very concise... I'm excited to see what's next!
I would love to see a video on stored procedures. What they are, why you would use them, maybe in context with Power BI or Paginated Reports.
Great video Patrik ;) Do you know if the OVER statement can generated in power query through the query folding? Or will it be in a near future ? Maybe a question for the master Alex Power?
Getting into window functions can save a ton of time for you.
Yes it can.
Is there a playlist with T-Sql videos?
We will work on one. Stay tuned!
Would use the Partition window daily. Just makes the day to day queries easy.
When you explain it, it all seems so simple.
PS
My SQL Server uses single quotes, not double quotes. That's weird
Love theese videos, but can you put and show us how you put what you write in a view or table and import it to powerbi. I know it sounds stupid but alot more people with catch on and it will bedome a smooth transition from a-b.
B A N A N A S
Just wondering if what you ve done here cant be done faster in power query in native query mode then copy paste bam, or copy paste to chat gpt to shorten/ check and bam done, aint this way a dinosour way :) ? I know not all can be done by nq but a lot