Forum Discussion
anandmarsh
8 years agoRegular Visitor
Power BI not recognising numerical values
Hi All, I have displayed some data from the excel file into a table in Power BI. 4 columns are text 1 column is nummerical Power BI doesnt recognise the numerical values (i.e. i cannot ...
Anonymous
2 years agoNot applicable
Hi there!
Someone have found solution about this topic?
I'm using the Version: 2.122.746.0 64-bit (Out/2023).
Power BI does not recognize excel column values with condition.
Excel and PBI were defined as number (decimal)
If you use the IFS conditional, it works well, but if you use IF conditional, PBI does not read the numeric values, it recognizes them as boolean (true or false | 0 or -1).
Some suggestion?
Thanks