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?
No, unfortunately there is anything in the db
Ther is just one field with no values for each record after the update.
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021