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

Dates From Last Sunday till End of Month

Hi Everybody, I would like to add two new columns to the date table in Desktop (not in the query):

 

  1. Column One: Retrun "Yes" for dates from first of the current month till last Sunday, otherwise "No"
  2. Column Two: Retrun "Yes" for dates from last Sunday till end of the current month, otherwise "No"

 

I already have a column for current month:

IsCurrentMonth = IF (YEAR ( Datetable[Date] ) = YEAR ( TODAY () )&& MONTH ( Datetable[Date] ) = MONTH ( TODAY () ), "Yes", "No" )

 

I would be grateful if you know how to build those two columns above. Many thanks!

1 ACCEPTED SOLUTION
reza_rad
MVP

This will give you the last Sunday: (as a measure)

TODAY()-WEEKDAY(today(),1)+1
 
and then you can use this in your if statement. 
 
Author, Consultant, Speaker
https://radacad.com

View solution in original post

2 REPLIES 2
reza_rad
MVP

This will give you the last Sunday: (as a measure)

TODAY()-WEEKDAY(today(),1)+1
 
and then you can use this in your if statement. 
 
Author, Consultant, Speaker
https://radacad.com

View solution in original post

Thank you very much Reza. I have the solution now!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors