Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello fellows,
This does not look correct to me,
It comes from https://docs.microsoft.com/en-us/powerquery-m/m-spec-values
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you for reply, but what is the use case of implement operator to a null value...?
User | Count |
---|---|
93 | |
86 | |
68 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |