Report Portal

Detect missing parameters in DAX queries

Yesterday I answered to a question related to parameters in DAX that could be useful to other readers who use DAX in Reporting Services (SSRS): how to manage missing parameters of a DAX query?

I wrote an article in the past describing how to use parameters in a DAX query, but what is not intuitive is that parameters are always strings. Thanks to automatic conversion of data type in DAX, a string can be easily converted into a number, so you do not see any difference until you have to manage the missing value. You might think that the missing value is passed as a blank, but this is not the case. For example, consider the following DAX query.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.