New article: Using join functions in DAX
NEW ARTICLE
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

 

POPULAR ARTICLES
 

BI-WEEKLY NEWS DIGEST
Latest news
• Power BI December 2023 updates
The main update is an on-object interaction preview feature. Microsoft is trying to address the negative feedback of existing Power BI users that found the new feature less productive. There is still a long way to go, but we are starting to see improvements.
Dec 12, 2023 · Microsoft
• Deep dive into DAX query view and writing DAX queries
This long and detailed description of the new DAX Query View feature in Power BI Desktop is what you need if you prefer written content. If you like videos, you should watch the "Unboxing DAX Query View in Power BI" video you can find in the YouTube section below!
Nov 30, 2023 · Microsoft
• Lakehouse vs. Data Warehouse in Fabric
Long story short: don't be obsessed by FOMO and FOBO. If your solution is working, keep going with it. We now have more options, but in the end, everybody still wants a SQL endpoint.
Dec 13, 2023 · Microsoft
• Use Fabric Notebook to monitor Power BI semantic models
You can run DAX queries and DMVs in a Fabric notebook. For example, to monitor your Power BI semantic models (formerly known as datasets). Yes, we know, it would be nice to have it in DAX Studio. Make a wish for 2024!
Dec 10, 2023 · Phil Seamark


SQLBI YOUTUBE CHANNEL
Latest videos