Power BI
NewChange IntelliSense Handling of "null" in Power Query from "Null.Type" to "null"
Vote
(6)
Joshua Hammond on 26 Sep 2021 01:22:29
When writing code in Power Query that includes null values, IntelliSense recommends "Null.Type". If you're writing out conditional statements, such as "if [A] > [B] then null", IntelliSense will insert ".Type" at the end of your expression when you hit space or enter/return. This can cause a lot of confusion for newer users and frustration for more advanced users. It is also incredibly difficult to find documentation on "Null.Type" in Power Query.
The default handling of null should be null.