Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 code table I have a territory, state, startzip and endzip. Is it possible with dax to make a new column that will take my zip code and look between the start and end zip, then return the territory?
Solved! Go to Solution.
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]))
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]))
Yes, you should be able to do this. You would filter your other table for rows where the start zip is less than your zip code AND the end zip is greater than your zip code. You could then use MAXX to return your territory name from that filtered table.
Specifics and testing would require sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |