Forum Discussion
Solved
FirstNonBlankValue and LastNonBlankValue not supported in Tabular SSAS15.0.32.50
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 P...
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
-
Thank you, this was helpful😊