Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Optimized null checking: measures or power query?

I am creating a number of "health reports" for my client, where I visualize the completeness and accuracy of their source system data. We're starting with the simplest question: what % of rows in eac...
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    From my point of view, if you're not using direct query mode for your dataset, Method 1 could be a better choice. :smileyhappy:

     

    Regards

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Forgot to explain the fnNullBool function:

 

(x) =>
let
nullCheck = Logical.From(if x = null then true else false)
in
nullCheck