Microsoft Power BI Cookbook

Single field address

1. Identify the following source columns for a new column Full Address to be used by the ArcGIS visual: street address (line 1), city, state or province, and postal or zip code. (Providing only a street address will result in inaccurate results.)
2. Include these columns in the SQL view used by the dimension table in the data model.
3. Create the Full Address column in the data model, either within the SQL view or by adding an M expression per the following example:

let Source = AdWorksProd, Customer = Source{[Schema = "BI", Item = "vDim_Customer"]}[Data],  FullAddress= Table.AddColumn(Customer, "Customer Full Address", each Text.Combine({[Address Line 1], [Customer City], [Customer State Province Code]}, ", ") & " " & [Customer ...