Lookup from 2 Column Ranges

[allenpee85]

Dear Community,

I have 2 column ranges (min and max) mapping table, how can i lookup to get the category name?

Many thanks.

[TomMartens · Accepted solution]

Hey @allenpee85 ,

I assume you are looking for a solution of "static segmentation", as it is described in this article:

https://www.daxpatterns.com/static-segmentation/

Regards,

Tom