Forum Discussion

Mahamood0218's avatar
Mahamood0218
Icon for Helper II rankHelper II
3 years ago
Solved

can not find age buckets

hi, i am not able to find age Buckets by using if statement , could you please suggest from 61 to 90days and >90days.   Thanks.
Need Help
Show and Tell
Tips and Tricks
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago
    age= IF('Date'[age]<=30,"<30days",IF('Date'[age]>=31 && 'Date'[age]<=60,"31 to 60 days",IF('Date'[age]>=61 && 'Date'[age]<=90,"61 to 90 days",IF('Date'[age]>90 ,">90days"))))
     
  • Anonymous's avatar
    Anonymous
    3 years ago

    try this:

     

    Bucket =
    SWITCH(
        TRUE(),
        Days[Days]<30,"<30days",
        Days[Days]<60,"30 to 60 days",
        Days[Days]<90,"60 to 90 days",
        ">90days"
    )
Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago
age= IF('Date'[age]<=30,"<30days",IF('Date'[age]>=31 && 'Date'[age]<=60,"31 to 60 days",IF('Date'[age]>=61 && 'Date'[age]<=90,"61 to 90 days",IF('Date'[age]>90 ,">90days"))))