Forum Discussion
List.RemoveItems Bug related to Number.NaN
Just ran into this and I think it's a bug. Say you have a simple list with NaNs in it and you want to remove them. Neither List.RemoveItems() nor List.RemoveMatchingItems() will remove the NaNs. See ...
You are using Number.NaN, but that doesn't appear to be a valid function in the number functions list:
https://learn.microsoft.com/en-us/powerquery-m/number-functions
--Nate
It's not a function, it's a constant. https://learn.microsoft.com/en-us/powerquery-m/number-nan
Ha, so it is! 🙂
---Nate