Group values by another table

[Anonymous]

Anyone know how to create custom sized groups to group values in PowerBI?

Preferably using another table that contains the ranges, so its easy to modify if needed. 

Bins are not useful for this.

For example grouping days between expected delivery date and actual delivery, which ranges from values -1000 to +1000

Less than -100

 -100 to -50

-49 to -20

-19 to -5

-4

-3

-2

-1

0

1

2

3

4

5-19

20-49

50-100
100+

[SpartaBI · Accepted solution]

If you want another table to be able to change it over there, than check out this: 
https://www.daxpatterns.com/static-segmentation/

You can also write the segmentation in a claculated column in the table itself, but, as oppose to the above method, in this case, only the model authour could change the logic of the segmentation, where in the above method, you could potentially put this segmentation table in a database and connect to it in direct query.

P.S. Don't think you need it for this case, but also take a look on the dax pattern for dynamic segmantation:
daxpatterns.com/dynamic-segmentation/