Please turn JavaScript on
SQLBI icon

SQLBI

Receive updates from SQLBI for free, starting right now.

We can deliver them by email, via your phone or you can read them from a personalised news page on follow.it.

This way you won't miss any new article from SQLBI. Unsubscribe at any time.

Site title: Error 404 (Not Found)!!1

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.16 / day

Message History

How to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller.


Read full story

This article describes how to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller.

When Microsoft announced that DAX User-defined functions (UDFs) are generally available (GA), another new feature was also announced: it is now possible to define optional parameters in a function and assign them...


Read full story

Learn the differences between similar but different DAX functions that remove filters from the filter context.


Read full story

DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions.

Computing values in DAX is all about understanding how to manipulate the filter context to obtain the desired output. DAX offers a wide variety of functions to manipulate the filter context, including a rich set d...


Read full story