Reply
Highlighted
Frequent Visitor
Posts: 3
Registered: ‎01-30-2018

Adding CountryZip - DAX or Power Query?

[ Edited ]

To show correct sales by Region or County, a one-to-many relationship between tables Geography and Sales must exist. Zip column alone can't be used to create a relationship because there are duplicate values in Geography[Zip]. To create unique set of values, a new column, CountyZip, is created in Geography which concatenates or combines the values of [County] & ", " & [Zip]. My question is: does it matter either in performance or in design if CountyZip is created in Power Query or through DAX?  I see Will uses DAX in the video.