DAX LastNonBlankValue

[Sweetie]

Hi, 

If we have 5 years of data for total month, quarter and year

May I know how to calculate last blank value

For each month

For each quarter

For each year

Using DAX.

[ERD · Accepted solution]

Hi @Sweetie ,

It's always better to show some input and desired result.

As for yor request, please refer to this article: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/ 

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[Sweetie]

Hi @ERD 

Yes, you are right with some input and desired output could have given much clarity.

Thanks for your time in providing me the right URL to go through.

Was very useful especially LASTDATE concept.