Hello,
I am trying to create a dashboard in Power BI using Microsoft Access Data, I have already converted the data from Access into Excel and have imported the data into Power BI query editor. While checking the data in the query editor, I noticed blank spaces for at least 3 columns (I have 14 columns in total). The 3 columns with missing data are: "Postal Code", "City", and "Address"
(More info on my project: I am trying to build a map of different workplaces in different cities. In my dashboard, I am planning on having a table with column names: "Workplace Name", "Address", "City", and "Postal Code" so that when a person choses a postal code, it shows where that workplace is)
As I mentioned, while looking through my data, I noticed that there are blanks in 3 of the columns mentioned above, I was wondering, if there is a DAX code that exists that can help me fill up the blanks for the address, postal code, and city, based on data available on Microsoft Access. For example, here is a sample of my Excel Sheet:
Workplace Name Address Postal Code City
Lashore Gold Organization 124 Sesame St L4M 2C1 Acton
Executer Prints (blank) L2C 5B6 Burlington
Panasoki View 36 Gervais Rd (blank) Timmins
Mining Way 14 Grey Blvd K0P 6O9 Sudbury
Raps Inc 20 Jane Dr N0P 1C4 (blank)
Spark Int 104 Spark St (blank) Perth
Inner Circle 22 University Rd N8O Y7O (blank)
Dixie Central Org (blank) N5R 8D6 Thunder Bay
As you can see, there are some blank spaces in the "Address", "Postal Code", and "City" columns, I was wondering, how can I fill up those blanks with the correct address, postal code or city info? I have a table in Access called "Employers" which contains the workplace names and their address, postal code, and city. I would like to know how I can use DAX or write a code to pull those information from the Access table to populate the blank field in Power BI. If you could help me out with this, I would really appreciate it!
thank you guys
