Forum Discussion
knotpc
Advocate I
Advocate ISearching between two columns for a value within a range (Zip Code)?
Hello, As I begin to migrate from Excel to Power BI, because the office loves the reports :), I keep getting stuck trying to identify formulas that will work in DAX. What a learning curve :). ...
ImkeF
Community Champion
Community ChampionThis problem is called "banding", "bucketing" or "segmentation". Have a look at this post: http://exceleratorbi.com.au/banding-in-dax/ where you find a DAX-approach or some M-alternatives in the comments. Or here another DAX: http://www.daxpatterns.com/static-segmentation/