07-21-2018 09:33 AM - edited 07-21-2018 09:39 AM
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.