Days going into the wrong buckets

[mluanacruz]

l all,
I have been bumping my head into the wall all day trying to figure out this formula and why it's not working.

I have this formula: 

Nol to pay buckets - case2 = IF([NOL to Payment]<=1,"Same Day",IF([NOL to Payment]>1 && [NOL to Payment] <=7,"1-7", IF([NOL to Payment] >7 && [NOL to Payment]<=10,"7 -10 Days",IF([NOL to Payment]>10 && [NOL to Payment] <=18, "10-18 Days",">10"))))

and the days listed in the pictures do not align with my formula.

Can you please advise?

Thank you, 

M

[PhilipTreacy · Accepted solution]

Hi @mluanacruz 

Download example PBIX file

How are you calculating your [NOL to Payment] measure?  Please provide the code.

With the sample data I set up and this measure

Nol to pay buckets = 

SWITCH(

    TRUE(),

    ISBLANK([NOL_to_Payment]), BLANK(),
    
    [NOL_to_Payment]<=1,"Same Day",

    [NOL_to_Payment]>1 && [NOL_to_Payment] <=7,"1-7", 
    
    [NOL_to_Payment] >7 && [NOL_to_Payment]<=10,"7 -10 Days",
    
    [NOL_to_Payment]>10 && [NOL_to_Payment] <=18, "10-18 Days",
    
    ">10")

Things seem to work correctly

Regards

Phil