Group range of numbers into buckets|Power Query|Excel Forum|My Online Training Hub

Hi Jason,

See attached file for solution using this code

if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 1 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 15 then "1-15"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 16 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 30 then "16-30"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 31 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 45 then "31-45"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 46 and [#"Difference in Days - Paid Date vs Last Scan Date"] <= 60 then "46-60"

else if [#"Difference in Days - Paid Date vs Last Scan Date"] > 60 then ">60"

else null

Regards

Phil