smart filtering in multisource report

[Anonymous]

I am building a Power BI report from multiple sources, that have diferent intervals of updates. Every update I place a new dump file in Sharepoint so I can compare the data and see old dashboards by filtering the report date.

The data looks like this:

What I want is some sort of smart filter:

select nothing: show maximum date (1-2-21 for risks, 1-1-21 for planning)

select feb-21 from date table: show  1-2-21 for risks, 1-1-21 for planning

select jan-21 from date table: (show 1-1-21 for both risks and planning

Do I need to enter this in every measure, (and if so: how?) Or is there some smart way of using the page-filter function?

[lbendlin · Accepted solution]

You might be able to use LASTNONBLANK(), LASTDATE(), or MAX() if all you want is to get the latest data from each feed based on your (disconnected) dates selection.

[Anonymous]

Yes, that kind of worked for me!

it has some drawbacks, at the meta-data is not filtered by this date. 

What did work was adding the date per visual as a filter and then set "Top 1 latest date".