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!
arkenstones Try this:
Last Sale Date Measure =
VAR __Table = FILTER( 'Table', [SalesAmount] <> BLANK() )
VAR __Result = MAXX( __Table, [Date] )
RETURN
__ResultHi Greg_Deckler
I appreciate your solution, but i was trying to learn the usage of
LASTNONBLANK() dax function but your recommendation does the job in an alternative way.
Thank you so much!
Thank you so much!