Date Slicer HELP

Sample data:

Month Net Asset

2018/1/1 100

2018/2/1 200

2018/5/1 300

2019/1/1 400

2019/2/1 500

2019/3/1 600

2019/5/1 700

For the line and column chart,

I want it shows in table(only select the newest value):

Month Net Asset

2019/5/1 700

How to do like that? Thanks

We have filters for date slicer, Asset Class, Group Name and Investment Product

Calendar = CALENDAR(MIN('data - fund level'[Month]), MAX('data - fund level'[Month]))

selected date = SELECTEDVALUE('Calendar'[Date])

flag3 =

CALCULATE (

MAX ( [Month] ),

FILTER (

ALLEXCEPT ( 'data - fund level',

'data - fund level'[Group Name], 'data - fund level'[Current CIFSC Asset Class],'data - fund level'[Investment Product Type] ),

[Month] <= [selected date]

))

Check = IF(LASTNONBLANK('data - fund level'[Month], 1)=[flag3],1,0)

LateAsset = CALCULATE(sum('data - fund level'[Net Assets])+0, Filter('data - fund level',[Check] = 1))

LateAsset should be the net assets I wanted but it runs wrong... Could someone help me check it?

Forum Discussion