Forum Discussion

VictorV's avatar
VictorV
Icon for Helper I rankHelper I
2 years ago
Solved

How to Return Latest Value in Column Based on Date

Hi everyone, I need help on this one, I want to create a measure that show lastest Amount based on month. For example, If I select month February, it will show lastest amount of January is 3000.   ...
General Comment
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    Does this measure work?

    Balance = calculate([Total],calculatetable(lastnonblank(calendar[date],calculate([Total])),datesbetween(Calendar[date],minx(all(calendar[date]),calendar[date]),min(calendar[date])-1)))
VictorV's avatar
VictorV
Icon for Helper I rankHelper I
2 years ago

Hi, tks for your replied, It close to what I want, I want it like if I select March, it will appear last value of Feb, in this case is 389, but your measure is the lastest value in that month instead

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Does this measure work?

Balance = calculate([Total],calculatetable(lastnonblank(calendar[date],calculate([Total])),datesbetween(Calendar[date],minx(all(calendar[date]),calendar[date]),min(calendar[date])-1)))