![SQLBI](/img/default-banner.jpg)
- 508
- 8 732 376
SQLBI
United States
Registrace 19. 10. 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
100K Subscribers - Thank you!
Watch the unboxing of the 100k subscribers plaque we received from CZcams!
zhlédnutí: 717
Video
Filter context in DAX explained visually
zhlédnutí 13KPřed dnem
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
zhlédnutí 23KPřed 21 dnem
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
zhlédnutí 6KPřed měsícem
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
zhlédnutí 19KPřed měsícem
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
zhlédnutí 9KPřed měsícem
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
zhlédnutí 7KPřed 2 měsíci
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
zhlédnutí 4,7KPřed 2 měsíci
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
zhlédnutí 10KPřed 2 měsíci
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
zhlédnutí 10KPřed 3 měsíci
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
zhlédnutí 7KPřed 3 měsíci
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
zhlédnutí 2,2KPřed 3 měsíci
Learn how to use the new Vpax obfuscator to send anonymized VPAX files to DAX Optimizer. Read more: www.tabulartools.com/blog/supporting-obfuscation-in-dax-optimizer/ Disclaimer of a potential conflict of interest: Marco Russo is one of the authors of DAX Optimizer and a founder of Tabular Tools, the company that produces and distributes it. Read more about the "unplugged" format: www.sqlbi.com...
Introducing VISUAL SHAPE for visual calculations in Power BI
zhlédnutí 20KPřed 3 měsíci
Introducing VISUAL SHAPE for visual calculations in Power BI
DAX Optimizer overview - Unplugged #56
zhlédnutí 8KPřed 3 měsíci
DAX Optimizer overview - Unplugged #56
Improve data labels with format strings
zhlédnutí 8KPřed 3 měsíci
Improve data labels with format strings
DAX limitations with row level security RLS
zhlédnutí 5KPřed 4 měsíci
DAX limitations with row level security RLS
Optimizing time intelligence in DirectQuery
zhlédnutí 5KPřed 4 měsíci
Optimizing time intelligence in DirectQuery
Differences between DATEADD and PARALLELPERIOD in DAX
zhlédnutí 7KPřed 5 měsíci
Differences between DATEADD and PARALLELPERIOD in DAX
Circular dependencies and relationships - Unplugged #55
zhlédnutí 5KPřed 5 měsíci
Circular dependencies and relationships - Unplugged #55
Replacing relationships with join functions in DAX
zhlédnutí 11KPřed 5 měsíci
Replacing relationships with join functions in DAX
Preparing a data model for Sankey Charts in Power BI
zhlédnutí 15KPřed 6 měsíci
Preparing a data model for Sankey Charts in Power BI
Computing accurate percentages with row level security in Power BI
zhlédnutí 7KPřed 7 měsíci
Computing accurate percentages with row level security in Power BI
Unboxing DAX Query View in Power BI - Unplugged #54
zhlédnutí 33KPřed 7 měsíci
Unboxing DAX Query View in Power BI - Unplugged #54
Computing MTD, QTD, YTD in Power BI for the current period
zhlédnutí 17KPřed 7 měsíci
Computing MTD, QTD, YTD in Power BI for the current period
Optimizing callbacks in a SUMX iterator
zhlédnutí 6KPřed 8 měsíci
Optimizing callbacks in a SUMX iterator
Using field parameters and calculation groups for conditional formatting
zhlédnutí 16KPřed 8 měsíci
Using field parameters and calculation groups for conditional formatting
You're worth it. And, "The only people you need to trust is ... " : czcams.com/video/A7JfANX8zIs/video.html
It depend! 🎉 Thank you for everx minutes❤
Well deserved 🎉🎉🎉
Congrats!!! ❤
Congratulations!
Gentlemen, calm down, make a picture of the trophy and you can share it with all your staff in all rooms.
Congratulations. I have been following you guys for about 6 years. I have a question that I would love for you to help me with. I want to justify my impact of applying best practice to a data model. Before: Previous Analyst wrote an SQL script to import data from Oracle into a Dataflow. Some additional steps were required in the Dataflow, which broke query folding: (i.e. remove columns / rename columns / replace blanks with 'C') The data from this Dataflow was loaded into Power BI. 8 additional Calculated Columns were created in Power BI (using DAX) to apply a complex fix to recategorized certain groupings based on a business logic. After: I rewrote the SQL to apply (remove columns / rename columns / replace blanks with 'C') in the script using a CTE and then I used a combination of CTEs and Window functions to perform the groupings that were previously performed in Power BI (using DAX) in one SQL script. The dataflow now has only one step and so is query folding. I no longer have any calculated columns in the semantic model. Correct me if I am wrong but I believe the steps that I did was following best practice but I am unsure of how I quantify what was the impact of re-writing the sql script. Any help would be much appreciated!
Congrats, guys!! I've learned so much from you. This is very much deserved!!
Happy to see you excited Maestros 🎉🎉🎉. Very well deserved. Have learnt a ton of things from your contents, which are really very deep in terms of knowledge.
Marco & Alberto or Mario & Luigi ? 👏👏😁!!
"Cutter, Cutter, Cutter, Cutter"
congrats guys...😎😎
Congrats Alberto and Marco. Well deserved 🎉🎉🎉
Congrats!!
Well deserved 😂
Congratulations 🎉 Thanks for everything !❤
Congratulations!!!
Thank you for every single one of your videos!
UNBOXING VIDEO UNBOXING VIDEO UNBOXING VIDEO
Congratulations! 🎉
Congratulations, Marco Russo, on reaching 100K subscribers! This is because of your hard work, dedication, and the value you bring to your audience. Here's to many more successes ahead! 🎉
Finally!! You’ve guys have been worth millions to all of us for years!! Congratulations 🎉
Congrats 🎉
Gold. Thanks
Congrats!! Very happy for you!! 🎉🎉🎉
Congratulations! More than deserved ✌
🏆Congratulations Maestros. 📊Thanks for sharing your knowledge💡 with the community👨🏻👩🏻👦🏻👦🏻! I hope it doubles very soon! 💯🚀
Congratulations🎉 . A must have !! One of the high quality content hosting channel on earth.
"unboxing video" * 3 ... "don't cut me" 😀. So well deserved. Thanks for spreading and sharing your knowledge. Such informative and beneficial content on here for all levels of users.
Great Job! 100K
Excited🎉 Congratulation
Congratulations!
Congratulations🎉alberto and Marco. You guys are awesome.
Very well deserved!!! 🎉🎉🎉
lol you two act like brothers 😂 congratulations!
Good to see the channel is growing🎉🎉🎉
Congratulations ! Well deserved 🙌🏼
Tks Marco. So usefull
Thanks.
This is gold, thanks
I have to add my 100 Euros to the last comment, very good tutorial and you saved me a lot of time waste! grandi ragazzi!
Is it better to use REMOVEFILTER( ) than ALL( )?
They are the same function. REMOVEFILTERS can be used only in CALCULATE, ALL is a table function when used outside of CALCULATE.
This really simplifies security roles! Would the performance be any different when transferring the selection of PermissionsExtended to Organization using TREATAS on the same relationship column in an RLS formula on Organization rather than the many-to-many relationship?
The relationship could give a performance advantage.
I cant stress enough how you guys from SQLBI rocks!!!! thanks a lo Ferrari, please come to Brazil!!!
Всё это, конечно, очень интересно... Только было бы гораздо понятнее на русском языке )))
Finished watching
Mr. Ferrari, thank you sir. I wish I had found this video 40 minutes ago but very glad nonetheless. So clean and simple! Tried other methods/videos to no avail.
Thanks a million! Very insightful!!!
Great Visualization, Where can I get this data set??
Download the sample file from the related article, the link is in the description!
Brilliant tutorial, thanks!