![SQLBI](/img/default-banner.jpg)
- Видео 510
- Просмотров 8 774 324
SQLBI
США
Добавлен 19 окт 2011
Learn and optimize DAX with Marco Russo and Alberto Ferrari - Visit www.sqlbi.com/?aff=yt.
We are experts on DAX and Data Modeling for Power BI, Analysis Services, and Power Pivot.
Visit our website to get more than 200 free articles, books, videos, and courses.
Free video courses:
- Introducing DAX: sql.bi/introdax/?aff=yt
- Introduction to Data Modeling for Power BI: sql.bi/intromodeling/?aff=yt
Advanced video courses:
- Mastering DAX: sql.bi/masterdax/?aff=yt
- Optimizing DAX: sql.bi/optimizedax/?aff=yt
- Data Modeling for Power BI: sql.bi/modeling/?aff=yt
- Power BI Dashboard Design Course: sql.bi/dashboard/?aff=yt
- SSAS Tabular Course: sql.bi/tabular/?aff=yt
- Power Pivot Workshop: sql.bi/powerpivot/?aff=yt
Our latest books:
- The Definitive Guide to DAX - 2nd edition: sql.bi/guidetodax/?aff=yt
- Analyzing Data with Power BI and Power Pivot for Excel: sql.bi/modelingbook/?aff=yt
We are experts on DAX and Data Modeling for Power BI, Analysis Services, and Power Pivot.
Visit our website to get more than 200 free articles, books, videos, and courses.
Free video courses:
- Introducing DAX: sql.bi/introdax/?aff=yt
- Introduction to Data Modeling for Power BI: sql.bi/intromodeling/?aff=yt
Advanced video courses:
- Mastering DAX: sql.bi/masterdax/?aff=yt
- Optimizing DAX: sql.bi/optimizedax/?aff=yt
- Data Modeling for Power BI: sql.bi/modeling/?aff=yt
- Power BI Dashboard Design Course: sql.bi/dashboard/?aff=yt
- SSAS Tabular Course: sql.bi/tabular/?aff=yt
- Power Pivot Workshop: sql.bi/powerpivot/?aff=yt
Our latest books:
- The Definitive Guide to DAX - 2nd edition: sql.bi/guidetodax/?aff=yt
- Analyzing Data with Power BI and Power Pivot for Excel: sql.bi/modelingbook/?aff=yt
Using atomic design in report and model development
The ‘atomic design methodology’ is an approach to make Power BI development more efficient and repeatable.
Article and download: sql.bi/844648?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Article and download: sql.bi/844648?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Просмотров: 8 734
Видео
100K Subscribers - Thank you!
Просмотров 1,7 тыс.16 часов назад
Watch the unboxing of the 100k subscribers plaque we received from RUclips!
Filter context in DAX explained visually
Просмотров 14 тыс.14 дней назад
A visual representation of the filter context in DAX can help understand the conceptual model. Article and download: sql.bi/843174?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Introducing the 3-30-300 rule for better reports
Просмотров 24 тыс.Месяц назад
A simple approach that you can apply to improve your reports and dashboards, not only in Power BI. Article and download: sql.bi/840130?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Understanding apply semantics for window functions in DAX
Просмотров 6 тыс.Месяц назад
Apply semantics is a new way of computing table expressions when multiple rows are selected in DAX window functions. Article and download: sql.bi/836012?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Writing DAX with ChatGPT-4o - Unplugged #58
Просмотров 19 тыс.Месяц назад
One year later, another special unplugged video where we write DAX measures with the new ChatGPT-4o! Previous video with ChatGPT-4: www.sqlbi.com/tv/writing-dax-with-chatgpt-4-unplugged-50/ Note: the first 20 seconds and the end of this video has a focus issue, sorry for that! Read more about the "unplugged" format: www.sqlbi.com/blog/marco/2021/01/09/the-unplugged-video-series-on-sqlbi-youtube...
Best practices for using KEEPFILTERS in DAX
Просмотров 9 тыс.Месяц назад
Best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Article and download: sql.bi/837707?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Comparing cumulative metrics for events with different start dates
Просмотров 8 тыс.2 месяца назад
How to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Article and download: sql.bi/836030?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Using EXPAND and COLLAPSE in visual calculations
Просмотров 4,7 тыс.2 месяца назад
See when EXPAND and COLLAPSE are required to obtain the correct result with visual calculations in Power BI. Article and download: sql.bi/833902?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Use scatterplots to find details in Power BI reports
Просмотров 10 тыс.3 месяца назад
Bubble plot, quadrant plot, volcano plot, joint plot, swarm plot: they are all types of scatterplot visuals to make more effective #powerbi reports. Learn how to use them in this video from Kurt Buhler! Article and download: sql.bi/832967?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt 00:...
Revolutionizing Power BI: Introducing the Ultimate Formula Language
Просмотров 10 тыс.3 месяца назад
Be the first to learn about the new #dax language extension, which will forever transform how we write #powerbi formulas for hierarchical calculations! Read the article: sql.bi/832843?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Introducing EXPAND and COLLAPSE for visual calculations in Power BI
Просмотров 8 тыс.3 месяца назад
Introduction to the two basic visual context navigation functions in DAX: EXPAND and COLLAPSE. There functions are used in Power BI visual calculations. Article and download: sql.bi/833882?aff=yt How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt
Vpax Obfuscator and DAX Optimizer - Unplugged #57
Просмотров 2,2 тыс.3 месяца назад
Vpax Obfuscator and DAX Optimizer - Unplugged #57
Introducing VISUAL SHAPE for visual calculations in Power BI
Просмотров 20 тыс.3 месяца назад
Introducing VISUAL SHAPE for visual calculations in Power BI
DAX Optimizer overview - Unplugged #56
Просмотров 8 тыс.3 месяца назад
DAX Optimizer overview - Unplugged #56
Improve data labels with format strings
Просмотров 8 тыс.4 месяца назад
Improve data labels with format strings
DAX limitations with row level security RLS
Просмотров 5 тыс.4 месяца назад
DAX limitations with row level security RLS
Optimizing time intelligence in DirectQuery
Просмотров 5 тыс.4 месяца назад
Optimizing time intelligence in DirectQuery
Differences between DATEADD and PARALLELPERIOD in DAX
Просмотров 7 тыс.5 месяцев назад
Differences between DATEADD and PARALLELPERIOD in DAX
Using tuple syntax in DAX expressions
Просмотров 8 тыс.5 месяцев назад
Using tuple syntax in DAX expressions
Circular dependencies and relationships - Unplugged #55
Просмотров 5 тыс.5 месяцев назад
Circular dependencies and relationships - Unplugged #55
Replacing relationships with join functions in DAX
Просмотров 11 тыс.6 месяцев назад
Replacing relationships with join functions in DAX
Preparing a data model for Sankey Charts in Power BI
Просмотров 15 тыс.7 месяцев назад
Preparing a data model for Sankey Charts in Power BI
Computing accurate percentages with row level security in Power BI
Просмотров 7 тыс.7 месяцев назад
Computing accurate percentages with row level security in Power BI
Unboxing DAX Query View in Power BI - Unplugged #54
Просмотров 33 тыс.7 месяцев назад
Unboxing DAX Query View in Power BI - Unplugged #54
Computing MTD, QTD, YTD in Power BI for the current period
Просмотров 17 тыс.7 месяцев назад
Computing MTD, QTD, YTD in Power BI for the current period
Optimizing callbacks in a SUMX iterator
Просмотров 6 тыс.8 месяцев назад
Optimizing callbacks in a SUMX iterator
Is this functionality possible when not connected via Analyze in Excel? In otherwords if I build a PowerPivot model in Excel, sourcing data from say Azure SQL, and I load all my tables in the Power Pivot model and create relationships, measures etc. Will it allow me to customize the drill-down details for a Power Pivot Table? If not in this way, is there another way which this can be done?
No you cannot - the model in Power Pivot does not allow that. You should be the model in either Power BI or Analysis Services.
Thank you very much. Great explanation. Simple and capacious.👍
Very well deserving 🎉🎉🎉🎉
I want to see this guy smile😂
congrats guys
So cute😂 🎉
Congrats! I learn a lot from you guys!
Congratulations guys.
That’s awesome. You reminded me of myself when I used to get a new toy 😅 Cheers!
AMAZING! THANKS
Awesome application of Brad Frost's principles! As another Atomic Design fan, it I great to see more people embracing what webdesign has to teach us in the data field. Outstanding video. - T, from Data Rocks.
Great tips, grazie Kurt ! You bring SQLBI to a whole new level 👌😊
Thank you, Jesus 👋
Amazing content. I have a doubt here. What if select a color and then try to change the Name. What will happen to the selected color value? Say the present name does not purchase that particular color. Thank you!
"And that is totally insane" 😂
Congratulations boys 🥇👏 now to the next 100K 😀
Loving this!
Congratulations
wait a minute... how did you get the Create A Jupyter Notebook external tool in your Power BI?!
Congratulations SQLBI guys, very happy for you 🎉❤
Top content, as usual.
Ciao Friends, You deserve it x100. Your contents are superb.
This is excellent. I would assume that the PBIP format and scripting could help overcome the limitations you pointed out when using the visualization library approach via a PBIX copy/paste?
Yes, eventually, this will be key.
You know DAX better than Microsoft 😮
Hello, thank you for the video, how have you calculated forecast measure?
Great, thank you
Hi, In this solution, suppose if we have multiple tables in the report. if we select the "others" in a table , the other table which displays all the product category names is not getting filtered. Is there a solution for this situation?
very helpful ! Would like to learn how to use the tabular editor
The Tabular Editor documentation has a lot of videos (and all the basic features are also in the free Tabular Editor 2 version): docs.tabulareditor.com/onboarding/index.html
WAIT UNTIL THE END LOL🤭
Congratulations Maestros!! Well deserved this Milestone.
Good video. Part 17:19 was also very instructive.
Great video! Helped me a lot. Thank you!
Stay on until the end for a great demo of how it all comes together :)
That ending. That's how I feel when I go back and look at models I created in the past. 😁
Great methodology! Love the ending!🙂
Lol, congratulations!🎉
Interesting concept
When I heard “atomic” I thought of dimensional design principle of bringing in data at the most detailed level. Transaction level instead of aggregation at Day level. Let’s see.
It's based upon a known methodology from UI/UX, whereby something complex is made by combining simple building blocks that you can apply as components to new solutions in a modular way.
I'm excited for this series of videos! Thanks again.
Enhorabuena a todo el equipo...Gracias por compartir un contenido de tanta calidad¡¡
This way is not working for 3 different slicers, Is there any other way to use OR clause with 3 different date filters/slicers
Great video and communicated well - love the D&D books and dragon (right hand side) and Dax book on the left - lol ending
Kurt is the Data Goblin after all. 💚
Which function did youtube use to count them? COUNT(), COUNTROWS(), DISTINCTCOUNT(), DISTINCTCOUNTNOBLANK() or what? 🙂
lol love the video, and alberto's jumping up and down - very well done chaps
This is golden!🎉
Hang it in your lounge. I assume you guys live together - right? 🤣 Congrats BTW!!
Absolutely no! :)
Parabéns, Marco e Alberto, por alcançarem 100 mil inscritos no RUclips! Vocês decodificaram o algoritmo do sucesso com a mesma maestria com que desvendam DAX e Power BI👏
Congratulations, you definitely deserve it
Congratulations, felicitazioni!
What was my rank 🤔, i don't remember but I 'm sure I was from the early one. Yes! I'm from the Veterans 🙂👍 like you guys even i still struggling with DAX😅