Forum Discussion

sajal161292's avatar
sajal161292
Helper V
8 years ago
Solved

To create groups on date table

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?

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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"
    )

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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"
    )