This article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabri| www.sqlbi.com
This article describes the differences between eager evaluation and strict evaluation in DAX, empowering you to choose the best evaluation type for your dat| www.sqlbi.com
The Optimizing DAX Workshop explains how to identify bottlenecks in DAX calculations, thus improving the performance of DAX formulas and Tabular data models.| www.sqlbi.com
This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result. In previous articles, w| www.sqlbi.com
COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose| www.sqlbi.com
This article describes how to correctly shape a data model and prepare data to use a Sankey Chart as a funnel, considering events related to a customer (con| www.sqlbi.com
This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. As do many languages, D| www.sqlbi.com
VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Power BI and Analysis Services Tabular. A complete description and sh| www.sqlbi.com