Forum Discussion
Solved
Help Needed on LASTNOBLANK dax function
Hi Friends, It may sound silly but im facing a problem in calculating lastnoblank sales date - https://github.com/kumarabhinay/Power_BI/blob/main/LastNoBlank.pbix I should get Jan 3rd as the las...
Hi Everyone,
https://github.com/kumarabhinay/Power_BI/blob/main/FirstLastNoBlank.pbix
A simple calculate function over the expression fixed the issue.I tried so hard using AI but failed. This simple tutorial reminded the concept of filter context required for these set of functions to work
Thank you very much!
Hi,
PBI file attached.
Hope this helps.
Hi Ashish_Mathur
Thank you for your reply. The solution definately solves the issue but again I wanted to use lastnoblank() function to see if I can get the last date of sales.
I think there is something wrong with my data. I will explore with another dataset and see if it works.
Thank you very much!