Date filter issue

[PaoloLevi]

Hi,

my PowerBi is connected to a db through a query.

The db is updated every hour, but not all the fields are updated at the same time.

The last field to be updated is updated weekly on Wednesdays, with the full previous week.

I need to filter the data in PowerBi to show the following for all fields:

until the Wednesday update: eveything until the Sunday of two weeks before

after the Wednesday update: everything until the previous Sunday

I have tried in several ways to filter the data, but without any success.

Does anybody know how to deal with this issue?

Thanks

Paolo Levi

[Anonymous]

Just wondered if there is any field that can indicate when the data is created or updated.

[PaoloLevi]

No, unfortunately there is anything in the db

Ther is just one field with no values for each record after the update.