YTD Values to be shown as 1 in a calculated column all other values as 2 based on date column

[Anonymous]

Hi Experts

Need a calcuated column measure which returns a value of 1 if the date falls with the YTD parameter and all future dates as 2. I have a date column in my FACT Table.

[amitchandak]

@Anonymous ,

a new column =

var _max = today()

var _min = date(year(_max),1,1)

return

Switch(True(),

[Date] >_max, 2,

[Date] <=_max and [Date] >=_min , 1,

0)

[Anonymous]

Hi Amit - Getting and error on this line of DAX "var _min = date(year(_max),1,1)"

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 
In amitchandak's formula, you need to replace 'and' with '&&'.
The formula should be something like as below: 

a new column =
VAR _max =
    TODAY ()
VAR _min =
    DATE ( YEAR ( _max ), 1, 1 )
RETURN
    SWITCH ( TRUE (), [Date] > _max, 2, [Date] <= _max && [Date] >= _min, 1, 0 )

Best Regards,
Community Support Team _ Eason