Forum Discussion
Post PatronHelp with DAX code filling in blank columns using data from Microsoft Access table
Community ChampionHi OPS-MLTSD ,
Go to Home tab, select Get Data, choose Access database and make the connection. This cuts out the Excel "middleman" and will hopefully be more successful.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Post PatronHello, even when I get the data directly from Access, the blanks are still there. I would like to know, how can I fill up those blanks?
In my case, I have several tables in my Access Database, I have combined 4 of those tables into one, and I am using information from that combined table that I created to create a dashboard on Power BI. But my problem is, there are several blank spaces in that Access table (please see above example for reference). My question, how can I fill up those blanks using information from other tables in Access. Unfortunately, for soem reason when I joined the tables together in Access, some rows still had blanks (I have checked with sevral sources, and the joining process was correct, so I knwo the problem isn't there).
Please let me know how I can fill up the blanks in Power BI.
thank you