please help in converting SQL query to Power Bi dax function - cal column

Hi Prathyusika ,

Please try the below code:

Time Bucket = 
    SWITCH(
        TRUE(),
        [ClosedDate] >= WM_START_DATE &&
        [ClosedDate] <= DATEADD(WM_START_DATE, 90, DAY) &&
        TODAY() >= WM_START_DATE, "90 Days",
        
        [ClosedDate] > DATEADD(WM_START_DATE, 90, DAY) &&
        [ClosedDate] <= DATEADD(WM_START_DATE, 180, DAY) &&
        TODAY() >= DATEADD(WM_START_DATE, 90, DAY), "180 Days",
        
        [ClosedDate] > DATEADD(WM_START_DATE, 180, DAY) &&
        [ClosedDate] <= DATEADD(WM_START_DATE, 270, DAY) &&
        TODAY() >= DATEADD(WM_START_DATE, 180, DAY), "270 Days",
        
        [ClosedDate] > DATEADD(WM_START_DATE, 270, DAY) &&
        [ClosedDate] <= DATEADD(WM_START_DATE, 360, DAY) &&
        TODAY() >= DATEADD(WM_START_DATE, 270, DAY), "360 Days",
        
        TRUE(), "Greater than 360 days"
    )

Best Regards,

Ajith Prasath

If this post helps, then please consider Accept it as the solution and give kudos to help the other members find it more quickly.