Forum Discussion

Jmccoy's avatar
Jmccoy
Icon for Helper II rankHelper II
6 years ago
Solved

DAX- New Column for territory

I have a table that contains project orders and a zip code for that order. I am trying to use a seperate territory zip code table to tie the project and the territories together. in my territory zip ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Assuming my 'Table' is your order table and 'Table (2)' is your area table, the dax formula should look something like this: 

    area = CALCULATE(VALUES('Table (2)'[area]); FILTER('Table (2)';'Table'[zip] >= 'Table (2)'[from] && 'Table'[zip] < 'Table (2)'[to]))

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Assuming my 'Table' is your order table and 'Table (2)' is your area table, the dax formula should look something like this: 

area = CALCULATE(VALUES('Table (2)'[area]); FILTER('Table (2)';'Table'[zip] >= 'Table (2)'[from] && 'Table'[zip] < 'Table (2)'[to]))