How to filter a page by last date and keep measures working?

[fellipea_ao]

Hello!
I have a dashboard that monitors the number of stocks per person per day. In one of the tabs, I illustrate the current day's data and compare it to the last working day. In another case I do the same analysis, but looking at 7 days.

There are two databases, one that informs the number of stocks per person per day and another that illustrates the closing price of the stock and the day. They are linked by date.

I created some measures to make comparisons between the current day and the previous day and seven days ago. Furthermore, I need both tabs to always be filtered by the last date found in the database.So, I cratead a calculated column that show last day, but when I use a slicer or use that column as filter page, the measures stop to work.
How can I solve this problem?

E.g: Here I'm using the normal filter, and filtered the last date 21/06/20204. Everything is working.

E.g: Here i used the "last day" in filter, using the calculated column that I have created.

Calculated column:

DataDescription = 
VAR _MaxDate = MAX(Amount[Date])
RETURN
IF(_MaxDate = Amount[Date], "Last Date", "Historical Date")

Measures that stoped to work (D-1 and D-7):

#Amount D-1
#Variation Amount D-1
%Variation Amount D-1
$Price D-1
%VariationPrice D-1

Here the link for pbix and database. 

[Ashish_Mathur · Accepted solution]

Hi,

Very confusd about what you want.  See my solution in the attached file.

 

[fellipea_ao]

Hello, @Ashish_Mathur . Thank you for reply, it's worked for me. I was trying to create a filter to use last date as start, but your solution is more refined.

[Ashish_Mathur]

You are welcome.