Project release every month

Thank you so much for your help!! I really appriciate it!!

The only problem left is with you measure ( if(day(today())<15), if I replcae 15 with the day(releasedate), I need to use the max or min function. like 

if(day(today()<day(max(ReleaseDate)). Because this will evalute for each month I combined it with month and the formula now is

Measure = if(day(today()) < day(max(Sheet1[Release Date]))&&  MONTH(TODAY())=month(max(Sheet1[Release Date])), if(year(max(Sheet1[Release Date]))=year(today())&&month(max(Sheet1[Release Date]))=month(today()),1),if(year(max(Sheet1[Release Date]))=year(today())&&month(max(Sheet1[Release Date]))=month(today())+1,1))

 

This results in 

How can we not include #4 as #2 and #3 have not been released yet.

 

Thanks!!!

Hi ryan_mayu

Thank you so much for your reply! I really appriciate this!!

The only problem left is in this part of your formula    if(day(today())<15), I replaced this with the day of the released date like if(day(today()) < day(max(RelaseDate)) but as this will evaluate for each month I combimed it with month(max(ReleasedDate)) condition.

Now the formula is 

This results in

Not sure how to NOT include #4 as #2 and #3 have not been released yet.

Thanks!!