Forum Discussion
Empty colums
I removed every column one by one so see when it went wrong.
It was the "opportunityid" column, data source is Dynamics CRM. Once I removed that column, every calculation worked like it should. It makes no sense, but hopefully this can help someone with the same issue.
Hi FrisoW ,
Unfortunately, I couldn't replicate this issue at my end with NULL values in a column.
I have one thought about the datatype of these columns. The column in your small video is of decimal type, but the few values I see in you column looks like whole number. Are they whole number type of values?
If yes, then before removing any empty values can you test one thing at your end please?
Rather than using Remove the Empty option can you just uncheck null from your values and see how it goes?
Also, just one thing to add, Power Query Editor always shows few rows from the dataset not every other row.
Just try this and let me know how this goes.
Thanks,
Pragati
I agree with Pragati11 with the 'filter out null' strategy. Let's hypothesise that there are some 'weird' values in the column so it will be very much down to you to debug and investigate the data.
Choosing the 'Remove Empty' option will generate some M code so it would be good if you could show us that please.
While you do that, you might investigate the column quality with the options on the 'View' menu (distribution, profile, quality) and also change the column profiling option to be based on entire dataset (just click the info under the data in power query).
If you're not getting anywhere you might investigate by removing the changing of the datatype to decimal. set it to text and re-check column values.
Let us know how it goes.