Please turn JavaScript on

SQLBI

follow.it gives you an easy way to subscribe to SQLBI's news feed! Click on Follow below and we deliver the updates you want via email, phone or you can read them here on the website on your own news page.

You can also unsubscribe anytime painlessly. You can even combine feeds from SQLBI with other site's feeds!

Title: Home - SQLBI

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.16 / day

Message History

How to implement a DAX function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function.


Read full story

In this article, we implement a function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function.

A DAX user-defined function, also known as a UDF, is expected to return a scalar or a table. However, because functions are fundamentally macro-expansion of DAX code, it is possible to return CALCULATE modifiers...


Read full story

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