Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When pivoting columns, I noticed that when a cell has null value, the entire row will not be included in the final result. I used to replace these null values with text (like "0," for example), but it looks like a blank() value will suffice. To replace null with blank values:
Select a column (or multiple columns) > Go to 'Transform' > Click 'Replace values' > In 'Value to find' field, type "null"; for the 'Replace with' field, leave it blank/empty > Click 'OK'
In the step's formula bar, you will find this syntax:
I hope this helps!
Solved! Go to Solution.
Hi @kymramosrpo ,
🌹🌹Nice sharing! I believe that some people will benefit from this.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kymramosrpo ,
🌹🌹Nice sharing! I believe that some people will benefit from this.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.