To create groups on date table

[sajal161292]

Hi,

I have  a calendar table as described below:

I would like to create groups on it like :

  if calendar[date] = today  then "0 day"

else if calendar[date] between today+1 and today+10 then "1-10 days"

else if calendar[date] between today+11 and today+20 then "11-20 days"

else if calendar[date] between today+21 and today+30 then "21-30 days"

and so on..

I am trying to use the switch over here but it is not working:

Column =
var x = today()
var y = DATESBETWEEN('Calendar'[new_date],x,x+11)
var z = DATESBETWEEN('Calendar'[new_date],y,y+11)
return SWITCH('Calendar'[new_date]=X,"0 DAY",'Calendar'[new_date]=y ,"1-10 days"))

Could you please help me in achieving this?

[Anonymous · Accepted solution]

Try this:

Column = 
VAR diff = Calendar[Date] - TODAY()
RETURN
    SWITCH(TRUE(),
        diff < 0, BLANK(),
        diff = 0, "0 days",
        diff <= 10, "1-10 days",
        diff <= 20, "11-20 days",
        diff <= 30, "21-30 days",
        "> 30 days"
    )