Forum Discussion
smart filtering in multisource report
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 ...
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.
lbendlin
Super User
Super UserYou 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.
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".