Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Is this an error in documentation?

Hello fellows,

 

This does not look correct to me, 

hsy_0-1597096684622.png

It comes from https://docs.microsoft.com/en-us/powerquery-m/m-spec-values

 

4 REPLIES 4
Christophe
Helper II
Helper II

I did a quick test and indeed this doesn't look correct. You cannot use "greater" or "less than" operators with null.

 

I'll leave feedback in the docs.

Indeed. if 1 > null then true else false just returns an error. 

I am not sure how that documentation could be correct. 



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
edhans
Super User
Super User

I do not believe so. I think that is telling you what operators work with null, not how values would compare to null using those operators.

I have a copy of the 2016 specifications in a PDF file and that same table is there.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Anonymous
Not applicable

Thank you for reply, but what is the use case of implement operator to a null value...?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.