Dates From Last Sunday till End of Month

[Anonymous]

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!

[reza_rad · 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. 

[Anonymous]

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