Forum Discussion
PowerWhy
3 years agoHelper IV
Less 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
3 years agoResident Rockstar
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.