FirstNonBlankValue and LastNonBlankValue not supported in Tabular SSAS15.0.32.50

[asirieka]

Hi, I'm using Tabular 15.0.32.50 and in my Tabular Model there are measures that use FirstNonBlankValue and LastNonBlankValue expressions. However, I get this error when I try to add a measure to a Power BI report connected to this model via SQL Server Analysis Service. 

From what I found, these expressions were released back in 2019. Can I know what version this syntax is supported in? 

[asirieka]

Thank you, this was helpful😊

[v-yiruan-msft · Accepted solution]

Hi @asirieka ,

According to the error message displayed in the screenshot, it seems that Power BI doesn’t recognize the function FirstNonBlankValue and  LastNonBlankValue. The following official documentations referred the info below:

• This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

FIRSTNONBLANKVALUE function (DAX) - DAX | Microsoft Learn

LASTNONBLANKVALUE function (DAX) - DAX | Microsoft Learn

You can consider upgrading to a newer version of Analysis Services. Alternatively, you may need to find a different way to achieve the same result using other functions that are supported in your current version of Analysis Services.

Best Regards