Summing assets based on dates from another table

You can have a measure as below:

Asset Last Date of previou fiscal = 

var _selD = SELECTEDVALUE(SumAssets_AssetTable[Date])
var _val = CALCULATE( Max(SumAssets_CalendarTable[Last Date of Previous Fiscal]), FILTER(SumAssets_CalendarTable, SumAssets_CalendarTable[Date] = _selD))
var _asset = CALCULATE(sum(SumAssets_AssetTable[Current asset]), SumAssets_AssetTable[Date] = _val)

RETURN if ( HASONEVALUE(SumAssets_AssetTable[Date]), _asset)

Say, you have the relationship as below:

Data as

Output will be as

To display exactly your needs, you can filter the visual as 

Hope this helps!