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 data with street intersections entered in different fields - Street and Cross Street. I am combining the 2 values in the Intersection1 column using CONCATENATE. See data screenshot
I need a way to say values with the same street names but in different order are the same. For example Main and Hastings is the same intersection as Hastings and Main. Is there an easy way to do this?
Solved! Go to Solution.
Hey @amulder , one approach might be to just sort the two streets in a predictable fashion (alphabetically) on each entry, so that even if the streets are reversed they are still sorted into a consistent order.
Here's an example of what I mean:
Intersection =
Var _FirstStreet = MIN(Intersections[Street], Intersections[Cross Street])
VAR _SecondStreet = MAX(Intersections[Street], Intersections[Cross Street])
Return
_FirstStreet & " " & _SecondStreet
This works exactly as required, thank you!
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 |
---|---|
115 | |
100 | |
90 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |