Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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

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
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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