What version of SSAS support the DAX expressions FIRSTNONBLANKVALUE and LASTNONBLANKVALUE

Subash Basnayake 51 Reputation points

I am using SSAS 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,171 questions
0 comments No comments
{count} vote