Forum Discussion
Missing Data
I have a dataset that has about 15,000 rows and 49 columns. In the image below, under "Loan Program" you can see I have 4 values missing. Two of them are the same value and the other 2 are different. I can't just "replace values" becasue they aren't all the same. Is there another way to add that data in the Query Editor inorder to not have to manually fix the exported spreadsheet before it is imported into Power BI Desktop?
Thanks!
Well, you could use an Enter Data query to just manually put in the values for all of the columns. Then you could filter those rows with blank values out of that query and then Append your Enter Data and that query together.
2 Replies
Well, you could use an Enter Data query to just manually put in the values for all of the columns. Then you could filter those rows with blank values out of that query and then Append your Enter Data and that query together.
Are these missing values in any way conditional on values in any other column?
