Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
100
Views
Topic starter
Can somebody help me explaining what's the difference between null and 0 values in Power Query? I want to use the data later on in PowerPivot calculations and I'm not sure if I should leave everything as is, convert null to 0 or the other way around.
Posted : 10/02/2017 5:00 am
Hi Rita,
In Power Query null is an empty cell, whereas a zero is a number. You can load your data as is into Power Pivot and the cells containing null will just appear empty.
Kind regards,
Mynda
Posted : 10/02/2017 10:23 pm
