Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Why the 'in the last' filter does not work?

‎10-11-2021 02:57 PM

Hello

 

I put a filter in Power Query to show the rows where the date is 'in the last 10 days' but it does not show the today's dates.

 

Is that expected?

 

How can I show everything in the last 10 days, so from now up to 10 days ago?

 

Thanks!

Labels:
Message 1 of 2
310 Views
0
1 ACCEPTED SOLUTION
Watsky
Solution Sage
Solution Sage

‎10-11-2021 03:27 PM

Hey @Anonymous ,

 

Try your filter like this:

 

Watsky_1-1633991253063.png

 

 


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

View solution in original post

Message 2 of 2
260 Views
0
1 REPLY 1
Watsky
Solution Sage
Solution Sage

‎10-11-2021 03:27 PM

Hey @Anonymous ,

 

Try your filter like this:

 

Watsky_1-1633991253063.png

 

 


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

Message 2 of 2
261 Views
0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All
Top Solution Authors
View All