display selected month trick not working on directquery mode

Anonymous

Hi pbuser,

In Direct Query mode, to ensure that queries sent to the underlying data source have acceptable performance, limitations are imposed on measures by default.

Both FORMAT and FIRSTNONBLANK Function are not supported for use in DirectQuery mode by default. Please see: https://msdn.microsoft.com/library/mt723603(SQL.130).aspx.

Advanced users can choose to bypass this limitation by selecting File > Options and then Settings > Options > DirectQuery, then selecting the option *Allow unrestricted measures in DirectQuery mode*. When that option is selected, any DAX expression that is valid for a measure can be used. Users must be aware, however, that some expressions that perform very well when the data is imported may result in very slow queries to the backend source when in DirectQuery mode.

Regards,