Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I have a problem with a load of data from an excel file, in which there are columns of decimal values, the decimal data there is no problem, but some of them the value is 0 and others is empty, when importing the data from excel to power query the values 0 appear as null and I can not differentiate them from the voids that are also incorporated as null. How can I make when importing the values that are 0 appear as zero and the voids as null?
Thanks for your help!
Hi @Syndicate_Admin ,
Unfortunately, I can't reproduce the scenario you described.
Is it still the same after changing the data type?
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |