NEW ARTICLE
Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic and provide the reasons why ALLSELECTED requires special attention.
Read more

 
DAX PATTERNS
The Events in Progress pattern has a broad field of application. It is useful whenever dealing with events with a duration – events that have a start date and an end date. The event is considered to be in progress between the two dates: contracts, insurances, tenures, and many other business entities have similar requirements.
Read more

 

SQLBI YOUTUBE CHANNEL
Latest videos
What happened in the DAX world in 2021
04:59#sqlbiMarco Russo
Optimizing SUMMARIZE by using ADDCOLUMNS
14:31#unpluggedAlberto Ferrari
Understanding the interactions between composite models and calculation groups
17:07#articleAlberto Ferrari
LN, LOG, LOG10, EXP
01:11#daxguideAlberto Ferrari
SINH, COSH, ASINH, ACOSH, TANH, ATANH, COTH, ACOTH
00:42#daxguideAlberto Ferrari
MEDIAN, MEDIANX
01:26#daxguideAlberto Ferrari
SQRT, POWER
01:14#daxguideAlberto Ferrari

 


BI-WEEKLY NEWS DIGEST
Latest news
• What is Tabular Editor and which license is right for you
This short, colorful, and well-written article explains why Tabular Editor is useful for Power BI development. It is part of a series dedicated to Tabular Editor that also explains how to choose the best license (there is also a free version).
Dec 4, 2021 · Kurt Buhler
• Using the Power BI Async REST API to refresh a partition with Power Automate
You don't need to write code to use REST APIs with Power Automate - but an article describing how to do that is beneficial: you still have to make the right choices among the options available!
Dec 12, 2021 · Gilbert Quevauvilliers
• Monitor Power BI queries and refreshes with DirectQuery on Log Analytics
This two-part series shows a handy use of DirectQuery in Power BI: to monitor the activity of your Power BI tenant in real time!
Jan 9, 2022 · Chris Webb