Lastnonblank help

[Kote101]

Hi, can anyone help me understand why my lastnonblank measure is giving me the max date (3/1/2022) even if its clear my last nonblank value is on (6/1/2019) https://i.gyazo.com/04b9f893b57d676f4881872c3f3147ed.png

[Zubair_Muhammad · Accepted solution]

Hi
Instead of sum only

Use calculate(sum)

[Kote101]

@Zubair_Muhammadthanks that worked, any idea why sum by it self wasnt working ? , i saw many examples where people used the same measure as i did but it worked.

[Ashish_Mathur]

Hi,

Read this article - https://exceleratorbi.com.au/lastnonblank-explained/.