how to find the last month latest historical record

[GreenMig]

Hi Everyone,
Could you please provide a best guide:
I am trying to find the lastest record my a history table.  I have created a table with the necessary filters below:

i_Updated_On = maximum (i_Updated_On for i_WorkspaceID)
i_Updated_On <= _first_of_month (current_date   )

I even tested it in a report so that when I apply them, I was able to find the correct record when these filters are applied at the query level.
However, when I apply these filters in a Dashboard either in the global filters or local filters I cannot obtain the correct results from a calculation using the resultant filtered records.

Not sure what I am doing wrong to obtain the correct records.

Mig

[BigChris]

I was able to find the correct record

Why not? What was wrong? What is that you want us to fix for you...it's not very clear from what you've posted.