cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jacqdr
Frequent Visitor

Determine if the Week Start has date for next month

Hi, 

 

Good day! I'm trying to filter if the week's start has value for the next month. 

 

Here's my data: 

 

jacqdr_0-1631841005775.png

 

 

Based on that date, I can filter in my report if it's within a selected month and check if there's a date for next month. 

 

jacqdr_1-1631841117552.png

 

Thank you. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
BCLS776
Super User
Super User

This filter calculates the month associated with a date 6 days in the future. If they are different they are returned in the filter, meaning the start date is in a different month than the end date:

Filter(myDataTable,
    Month('Week Start') <> Month(DateAdd('Week Start',6,Days))
)

You can get the opposite filter by replacing the <> with =

 

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

1 REPLY 1
BCLS776
Super User
Super User

This filter calculates the month associated with a date 6 days in the future. If they are different they are returned in the filter, meaning the start date is in a different month than the end date:

Filter(myDataTable,
    Month('Week Start') <> Month(DateAdd('Week Start',6,Days))
)

You can get the opposite filter by replacing the <> with =

 

Hope that helps,

Bryan

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,448)