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

Thanks a lot, it's work perfect

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

You are welcome.