cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Date filter issue

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

2 REPLIES 2
Highlighted
Advocate I
Advocate I

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

No, unfortunately there is anything in the db

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors