Forum Discussion

Bu__'s avatar
Bu__
Frequent Visitor
3 years ago
Solved

To group a numeric column containing the difference between 2 dates into same_day, day+1, >1 day

i want to convert a numeric column containing difference between 2 dates like (0,1,2,3..... so on) into 3 groups --> same_day, d+1 and >1 day How to convert the numeric column and categorize them in...
DAX
group
pareto
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Bu__ 

    please try
    =
    SWITCH (

    [days between],
    0, "same day",

    1, "D + 1 day",

    "> 1 day"

    )

  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Bu__ 

    try like:

    categories =
    SWITCH(
        TRUE(),
        [days between]=0, "same_day",
        [days between]=1, "d+1", 
        ">1 day"
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Bu__ 

try like:

categories =
SWITCH(
    TRUE(),
    [days between]=0, "same_day",
    [days between]=1, "d+1", 
    ">1 day"
)