Max date filtering in measure to show last record string

[Anonymous]

Hei!

I have a table lookinbg like the picture above. The records save the summary per reporting period for each time a user makes changes.

I have a way to get the final record for each period with a flag of 1:

Maxdate = calculate(max(modified_on); filter(table, reporting_period))

Lastrecordflag = if(max(modified_on)= maxdate;1;0)

I want to show in a card the final summary (based on modified_on and the flag above) for the last period available on the page.

For example, now I would see Texte 1.11 since that is the final version of the final period (6). However, if I choose in the slicer period 5, then I will see Text 1.6. So the summary showing will always the the last one available given the data on the page.

I have tried many different versions but not getting it right.

test =

var datemax = MAX(reporting_period)

return CALCULATE(MAX(summary);filter(table;and([Lastrecordflag]=1;reporting_period=datemax)))

[Anonymous]

I am actually trying to show only the summary in a table not card (since I want it left aligned. Thought this might be important to mention since the behavior can be different.