Calculated column Measure >= today and <= to end of current year

[Anonymous]

Hi Experts

need  a calculated columne measure that give me a 1 where the date base on the milestone date are  >= today and <= to end of current year.

[themistoklis · Accepted solution]

Hello @Anonymous 

Try the following formula:

Calculated Column = IF(Sheet1[Dates]>=TODAY() && ENDOFYEAR(Sheet1[Dates]),1,0)

[Anonymous]

Hi have Tried
rest of yr = 
VAR -enddate = DATE(YEAR(TODAY()),12,31)
Return
If(m[date] > Today() <=_enddate,1,0)