New Semi Join, Anti Join And Query Folding Functionality In Power Query
There are a couple of nice new features to do with table joins (or merges as they are known in M) and query folding in Power Query in the April release of Power BI Desktop that I want to highlight. Anti Joins now fold First of all, a few months ago I wrote a post … Continue reading New Semi Join, Anti Join And Query Folding Functionality In Power Query
Published on:
Learn moreRelated posts
Using RANK instead of RANKX in DAX
2 days ago
Deprecating Power BI Q&A
We are announcing the deprecation of Q&A, our legacy natural language tool, which will take place in December 2026. Moving forward, users ...
3 days ago
A Look At The Impact Of Calendar Based Time Intelligence On Power BI DirectQuery Performance
Calendar-based time intelligence (see here for the announcement and here for Marco and Alberto’s more in-depth article) is at least the ...
4 days ago
Boost Your Dashboards: The Role of Visual Calculations in Power BI
Visual Calculations in Power BI play a transformative role by allowing users to write calculations directly within a visual, simplifying analy...
6 days ago
Fix ANY Date Format in Excel with Copilot Function – no Power Query – no Macros!
Fix ANY Date Format in Excel with Copilot Function without any Macros. Got dates in multiple, different and difficult formats? No problem. ...
7 days ago