www.sqlbi.com
Open in
urlscan Pro
20.119.0.24
Public Scan
Submitted URL: http://www.sqlbi.com/
Effective URL: https://www.sqlbi.com/
Submission: On January 24 via api from US — Scanned from DE
Effective URL: https://www.sqlbi.com/
Submission: On January 24 via api from US — Scanned from DE
Form analysis 3 forms found in the DOM
https://www.sqlbi.com
<form action="https://www.sqlbi.com">
<div class="compressed-input">
<input type="text" name="s" placeholder="Search for articles, videos and tools" value="" required="">
</div>
</form>https://www.sqlbi.com
<form action="https://www.sqlbi.com">
<div class="compressed-input">
<input type="text" name="s" placeholder="Search for articles, blog posts, and videos" value="" required="">
<input type="hidden" name="type" value="">
<button class="button">Search</button>
</div>
</form><form class="subscription">
<div class="compressed-input">
<input type="hidden" name="nlnl[]" class="nlnl" value="41">
<input type="email" name="nlemail" class="nl-email" placeholder="Your email address" required="">
<button class="nl-subscribe button">Subscribe</button>
</div>
<div class="note"> By subscribing you are agreeing to our <a href="https://www.sqlbi.com/privacy/">Privacy Policy.</a></div>
<div class="failed"></div>
</form>Text Content
* * Home * Training * Consulting * Articles & Blog * Videos * Books * Tools * About * Menu * Search * 0 * LOGIN * Home * Training * Consulting * Articles & Blog * Videos * Books * Tools * About Search Feb 27-29, 2024 Dallas, TX, US Register now Jan 15, 2024 USING TUPLE SYNTAX IN DAX EXPRESSIONS Marco Russo & Alberto Ferrari This article describes the use of the tuple syntax in DAX expressions to simplify comparisons involving two or more columns. Read more Jan 1, 2024 REPLACING RELATIONSHIPS WITH JOIN FUNCTIONS IN DAX Marco Russo & Alberto Ferrari This article describes how to join tables in DAX when there are no relationships in the data model. The data lineage plays an essential role in this scenario. Read more Previous 23:23 REPLACING RELATIONSHIPS WITH JOIN FUNCTIONS IN DAX Watch now 32:24 USING TUPLE SYNTAX IN DAX EXPRESSIONS Watch now 32:30 CIRCULAR DEPENDENCIES AND RELATIONSHIPS – UNPLUGGED #55 Watch now 23:23 REPLACING RELATIONSHIPS WITH JOIN FUNCTIONS IN DAX Watch now 32:24 USING TUPLE SYNTAX IN DAX EXPRESSIONS Watch now 32:30 CIRCULAR DEPENDENCIES AND RELATIONSHIPS – UNPLUGGED #55 Watch now 23:23 REPLACING RELATIONSHIPS WITH JOIN FUNCTIONS IN DAX Watch now Next * 1 * 2 * 3 WE TEACH DAX AND DATA MODELING ALL AROUND THE WORLD Previous * Feb 27-29 - Dallas * Mar 4-6 - Amsterdam * Apr 15-17 - New York City * May 6-8 - Seattle * Jul 2-4 - Amsterdam * Feb 27-29 - Dallas * Mar 4-6 - Amsterdam * Apr 15-17 - New York City * May 6-8 - Seattle * Jul 2-4 - Amsterdam * Feb 27-29 - Dallas * Mar 4-6 - Amsterdam * Apr 15-17 - New York City * May 6-8 - Seattle Next * 1 * 2 * Jul 2-4 - Amsterdam * Feb 27-29 - Dallas * Mar 4-6 - Amsterdam * Apr 15-17 - New York City * May 6-8 - Seattle More courses Video Training INTRODUCING DAX VIDEO COURSEFREE Dec 29, 2023 WHAT HAPPENED IN THE DAX WORLD IN 2023 Marco Russo Our end-of-the-year tradition is to recap what happened in the DAX and SQLBI world and look at what is coming next. Read more Dec 18, 2023 USING JOIN FUNCTIONS IN DAX Marco Russo & Alberto Ferrari This article describes the practical uses of NATURALLEFTOUTERJOIN and NATURALINNERJOIN in DAX. These functions are not commonly used in DAX because they do not have the same flexibility as the corresponding concepts in SQL. Read more DAX Patterns RELATED DISTINCT COUNT The Related distinct count pattern is useful whenever you have one or more fact tables related to a dimension and you need to perform the distinct count of column values in a dimension table only considering items related to transactions… More on DAX Patterns -------------------------------------------------------------------------------- SQLBI Corp. DAX PATTERNS, SECOND EDITION A pattern is a general, reusable solution to a frequent or common challenge. This book is the second edition of the most comprehensive collection of ready-to-use solutions in DAX, that you can use in Microsoft Power BI, Analysis Services Tabular, and Power Pivot for Excel. Read more * 293 articles * 773 posts * 436 videos * 12 books * 12 papers * 30 tools Popular topics * DAX * SSAS * Power BI * Tabular * Power Pivot * MDX * BISM * Excel * Optimization * PowePivot * Conference * Time Intelligence * VertiPaq * Communities * PASS NEWSLETTER Subscribe By subscribing you are agreeing to our Privacy Policy. 220.0K subscribers Get BI news and original content in your inbox every 2 weeks! Newsletter archive WHAT IS NEXT * Mastering DAX – Feb 27, Dallas * Mastering DAX – Mar 4, Amsterdam * Mastering DAX – Apr 15, New York City * Mastering DAX – May 6, Seattle * Mastering DAX – May 14, Hamburg * Mastering DAX – May 22, Copenhagen * Mastering DAX – Jun 25, Chicago YouTube Twitter LinkedIn Facebook Github RSS Feed Marco Russo Alberto Ferrari Daniele Perilli 2004-2024 © SQLBI. All rights are reserved. SQLBI is a trademark of SQLBI Corp. Loader is a European legal entity. Privacy Policy & Cookies Terms & Conditions Contact Us * * * * * * * Notifications THIS WEBSITE USES COOKIES We use cookies to personalize content and ads, to provide social media features and to analyze our traffic. We also share information about your use of our site with our analytics partners who may combine it with other information that you have provided to them or that they have collected from your use of their services. You consent to our cookies if you continue to use our website. Cookies Policy Use necessary cookies only Allow all cookies * Archive * Restore