Forum Discussion
How to fix dax operation error using Values or Format in the string
All negative numbers start with ' is this expected?
Eg: '-0999
Hi Mk60
From your screenshots, you can see that the data type of the "F_PROP_DSCR" column is "Text", and the reason for the error in the DAX formula is that you can't compare the text with the value.
I think what you need to do is to clean up your data in Power Query Editor and change the "F_PROP_DSCR" column to numeric type. Then this DAX formula will work successfully.1. Change the “F_PROP_DSCR” column to a numeric type in the Power Query Editor.
2. Remove error rows or replace error rows.
If there are fewer rows of text, you can also choose to manually replace the text value with the correct numeric value.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Mk60 , as a mentioned, your table contains really text, thats why will not allow you to change data type, thats why i asked a sample file, can be with only this column, to see closer the problem. maybe are there spaces or anything that is numeric.
Make sure to not share a sensitive information:
Unfortunately I don't have good option to send you just this column in PBI file. I tried to export few columns in excel, but can't attach it here. This is a sample of that colum, not sure if this could be of any reference at all?
Hi Mk60,
You can upload to onedrive and share the link for download here in comments.
Thank you for that suggestion. I requested my data provider to see if he can change the field format and I could update my table. If that does not happen, I'll try your suggestion and create onedrive account, as I do not have one right now. Trully apprecite your willingnes to help Bibiano_Geraldo!
Can be in any cloud service, onedrive was my suggestion, but you can check if the values are number in excel using isnumber function, this will return true if yes, if not will return false