Forum Discussion
PowerWhy
Helper IV
3 years agoLess than filter unexpected behaviour
Hello, For this file https://www.dropbox.com/s/6pn9gcjg9zmmu6m/Test%20-%20Less%20than%20filter%20unexpected%20behaviour%20-%20Dec%2022.pbix?dl=0 please can someone tell me why the right table is ...
Mikelytics
Resident Rockstar
3 years ago
Maybe the raw data are like 0,399999999999999999999999999 for one row and fot hte others not? you have so many decimal numbers. Maybe you should do rounding in Power Query to two decimals.
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.