Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
In the later part of the Relational Operators chapter, it is mentioned: "If either operand is #nan, the result is false for all relational operators". Similar content is mentioned in the IEEE 754 standard, but in fact, in M, #nan will be less than any value. For example: #nan < 5 is "true".
So far, this is not a problem, but this expression will evaluate to "false" in DAX.This result is confusing, why is it so?
Solved! Go to Solution.
You would have to ask Ben Gribaudo.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
33 | |
32 | |
20 | |
15 | |
13 |
User | Count |
---|---|
20 | |
18 | |
15 | |
10 | |
10 |