Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |