Share via

What version of SSAS support the DAX expressions FIRSTNONBLANKVALUE and LASTNONBLANKVALUE

Subash Basnayake 61 Reputation points
2023-09-13T14:22:23.0533333+00:00

I am using SSAS 15.0.32.50 and I used FIRSTNONBLANKVALUE and LASTNONBLANKVALUE DAX expressions in my measures. The model gets deployed without an issue but when I try to use these measures I get an error "Expression: Failed to resolve name 'FIRSTNONBLANKVALUE'. It is not a valid table, variable, or function name."

In Microsoft documentation, I can't find the SSAS versions supporting this syntax.

When I deploy the same model to azure analysis service it works without this error but AAS is in the latest release.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,307 questions
0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.