Display in a card the last non blank value

[kmartink]

Hi, I'm using this Data:

and would like to build a measure to display in a card the last non blank value per each variable. Any suggestions? Thank you in advance!

[ryan_mayu]

@kmartink 

you can try to create a date column

date = date('Table'[Year],'Table'[Month],1)

then create a measure

measure = CALCULATE(sum('Table'[x]),LASTNONBLANK('Table'[date],CALCULATE(sum('Table'[x]))))