Show only latest month data value

Hi PattemManohar,

With this 

Last Balance =
VAR _MaxDate = MAXX(ALL(Table1[vuosikk]);Table1[vuosikk])
VAR _Result = IF(FIRSTNONBLANK(Table1[vuosikk];1)=_MaxDate ; sum(Table1[peruslaskukaava]);BLANK())
RETURN _Result

I got it working, that it shows only for the latest yearmonth value. But in this option, I have to click from the table "rows" dimension "show items with no value" to show it the way I want it to be seen.

vuosi vuosikk Last Balance
2018 201803 390

vuosi vuosikk Last Balance
2017 201701 (Blank)
2017 201711 (Blank)
2017 201712 (Blank)

2018 201801 (Blank)

2018 201802 (Blank)

2018 201803 390

Thanks for your input tho'! It got my brains rolling and was helpful for me :) If you have any other solution, please, share!

Cheers,
Niko