SQLBI
SQLBI
  • 508
  • 8 732 376

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
Introducing SQLBI Days
zhlédnutí 2,6KPřed 4 měsíci
Introducing SQLBI Days
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
Using tuple syntax in DAX expressions
zhlédnutí 8KPřed 5 měsíci
Using tuple syntax in DAX expressions
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
What happened in DAX in 2023
zhlédnutí 6KPřed 6 měsíci
What happened in DAX in 2023
Using join functions in DAX
zhlédnutí 10KPřed 6 měsíci
Using 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

Komentáře

  • @holahandstrom
    @holahandstrom Před 2 hodinami

    You're worth it. And, "The only people you need to trust is ... " : czcams.com/video/A7JfANX8zIs/video.html

  • @sarajvo2010
    @sarajvo2010 Před 4 hodinami

    It depend! 🎉 Thank you for everx minutes❤

  • @Dzidza1978
    @Dzidza1978 Před 4 hodinami

    Well deserved 🎉🎉🎉

  •  Před 5 hodinami

    Congrats!!! ❤

  • @fpa89
    @fpa89 Před 5 hodinami

    Congratulations!

  • @vanlessing
    @vanlessing Před 5 hodinami

    Gentlemen, calm down, make a picture of the trophy and you can share it with all your staff in all rooms.

  • @PBIWizard
    @PBIWizard Před 5 hodinami

    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!

  • @gustavobarbosa906
    @gustavobarbosa906 Před 6 hodinami

    Congrats, guys!! I've learned so much from you. This is very much deserved!!

  • @sanjeevgupta7177
    @sanjeevgupta7177 Před 6 hodinami

    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.

  • @spilledgraphics
    @spilledgraphics Před 7 hodinami

    Marco & Alberto or Mario & Luigi ? 👏👏😁!!

  • @asjones987
    @asjones987 Před 7 hodinami

    "Cutter, Cutter, Cutter, Cutter"

  • @ShivanshuSingh-u9r
    @ShivanshuSingh-u9r Před 7 hodinami

    congrats guys...😎😎

  • @faisalag9611
    @faisalag9611 Před 8 hodinami

    Congrats Alberto and Marco. Well deserved 🎉🎉🎉

  • @reng7777
    @reng7777 Před 8 hodinami

    Congrats!!

  • @luisfernandomacedo1451
    @luisfernandomacedo1451 Před 8 hodinami

    Well deserved 😂

  • @adityabidkar9395
    @adityabidkar9395 Před 8 hodinami

    Congratulations 🎉 Thanks for everything !❤

  • @elrevesyelderecho
    @elrevesyelderecho Před 8 hodinami

    Congratulations!!!

  • @visheshjjain
    @visheshjjain Před 8 hodinami

    Thank you for every single one of your videos!

  • @ChuckJacobson
    @ChuckJacobson Před 8 hodinami

    UNBOXING VIDEO UNBOXING VIDEO UNBOXING VIDEO

  • @momopeaches
    @momopeaches Před 8 hodinami

    Congratulations! 🎉

  • @xeeshanahmad8757
    @xeeshanahmad8757 Před 9 hodinami

    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! 🎉

  • @daustonian9331
    @daustonian9331 Před 9 hodinami

    Finally!! You’ve guys have been worth millions to all of us for years!! Congratulations 🎉

  • @boonyarithdumrongpalasith5501

    Congrats 🎉

  • @ruthwickm4984
    @ruthwickm4984 Před 9 hodinami

    Gold. Thanks

  • @pablogenero1678
    @pablogenero1678 Před 9 hodinami

    Congrats!! Very happy for you!! 🎉🎉🎉

  • @user-xf1uh4ro2z
    @user-xf1uh4ro2z Před 9 hodinami

    Congratulations! More than deserved ✌

  • @paulosergiorocha2084
    @paulosergiorocha2084 Před 9 hodinami

    🏆Congratulations Maestros. 📊Thanks for sharing your knowledge💡 with the community👨🏻‍👩🏻‍👦🏻‍👦🏻! I hope it doubles very soon! 💯🚀

  • @Nalaka-Wanniarachchi
    @Nalaka-Wanniarachchi Před 9 hodinami

    Congratulations🎉 . A must have !! One of the high quality content hosting channel on earth.

  • @josephansah
    @josephansah Před 9 hodinami

    "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.

  • @georgipetkov7016
    @georgipetkov7016 Před 9 hodinami

    Great Job! 100K

  • @gopichand5717
    @gopichand5717 Před 9 hodinami

    Excited🎉 Congratulation

  • @RichardOliver
    @RichardOliver Před 9 hodinami

    Congratulations!

  • @qasimali-gu3oz
    @qasimali-gu3oz Před 9 hodinami

    Congratulations🎉alberto and Marco. You guys are awesome.

  • @reemAlosherey
    @reemAlosherey Před 9 hodinami

    Very well deserved!!! 🎉🎉🎉

  • @TheDukeNY
    @TheDukeNY Před 9 hodinami

    lol you two act like brothers 😂 congratulations!

  • @amarnadhgunakala2901
    @amarnadhgunakala2901 Před 9 hodinami

    Good to see the channel is growing🎉🎉🎉

  • @joserafaelfarfanfernandez899

    Congratulations ! Well deserved 🙌🏼

  • @rinmai9225
    @rinmai9225 Před dnem

    Tks Marco. So usefull

  • @ceyhunozturk5115
    @ceyhunozturk5115 Před 2 dny

    Thanks.

  • @fpa89
    @fpa89 Před 3 dny

    This is gold, thanks

  • @dariush7272
    @dariush7272 Před 3 dny

    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!

  • @eduduazzolin
    @eduduazzolin Před 4 dny

    Is it better to use REMOVEFILTER( ) than ALL( )?

    • @SQLBI
      @SQLBI Před 3 dny

      They are the same function. REMOVEFILTERS can be used only in CALCULATE, ALL is a table function when used outside of CALCULATE.

  • @martinbubenheimer6289

    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?

    • @SQLBI
      @SQLBI Před 3 dny

      The relationship could give a performance advantage.

  • @hellmutmatheus2626
    @hellmutmatheus2626 Před 4 dny

    I cant stress enough how you guys from SQLBI rocks!!!! thanks a lo Ferrari, please come to Brazil!!!

  • @user-ui2wu6mm9l
    @user-ui2wu6mm9l Před 4 dny

    Всё это, конечно, очень интересно... Только было бы гораздо понятнее на русском языке )))

  • @user-lm5wb8vi1x
    @user-lm5wb8vi1x Před 5 dny

    Finished watching

  • @davidmorrical9763
    @davidmorrical9763 Před 5 dny

    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.

  • @brendali5803
    @brendali5803 Před 5 dny

    Thanks a million! Very insightful!!!

  • @AtulayaShrivastava
    @AtulayaShrivastava Před 6 dny

    Great Visualization, Where can I get this data set??

    • @SQLBI
      @SQLBI Před 5 dny

      Download the sample file from the related article, the link is in the description!

  • @tibibara
    @tibibara Před 6 dny

    Brilliant tutorial, thanks!