Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[SUBASH KINATTERI PARAMBIL]

Hi Team,

I have two tables in excel like below and I want to compare  the” Numbers” column in both the tables. The Numbers column may contain numbrs/ alphabets / or some times alpha numeric characters etc. when I define this Data type in DAX I can’t put either Text or whole number because it may change in different times. Is there any solution to fix this error like below.

Number	Value
2200	100
2000-5	200
2000A	10
ABCD	20.00

 

Number	Value
2000	300
6000	200
4000	10
ABCD	20.00

Error in Linked tables

There were errors trying to update one or more linked tables.  Use Options below to see ways to fix these problems, or OK to continue without fixing them.

Expecting your valuable suggestions

Thanks 
Subash

——————————
SUBASH KINATTERI PARAMBIL
ACCOUNTS OFFICER
BUR DUBAI
971507471257
——————————

[Cory Swindle]

If I am understanding you clearly, you can define the number column as TEXT which will save the actual value and allow you to have any type of character in that field.  If that does not return what you are looking for, you can try the VALUE function to see if that will work for you.

VALUE Function (DAX)

Microsoft		remove preview
VALUE Function (DAX) You can also use column references. For example, if you have a column that contains mixed number types, VALUE can be used to convert all values to a single numeric data type. However, if you use the VALUE function with a column that contains mixed numbers and text, the entire column is flagged with an error, because not all values in all rows can be converted to numbers. View this on Microsoft >

——————————
Cory Swindle
Application Data Analyst
Liquid Environmental Solutions
Dallas TX
214-563-3410
——————————
——————————————-

[SUBASH KINATTERI PARAMBIL]

Dear Cory,

Can you please check the attached excel file with DAX formulas in it.  Why I am not able to update the table data in supplier sheet.  The below error message is getting. ( both the table contain all text data)

“There were errors trying to update one or more linked tables. Use Options below to see ways to fix these problems, or OK to continue without fixing them”

Please help

Regards,

Subash

——————————
SUBASH KINATTERI PARAMBIL
ACCOUNTS OFFICER
BUR DUBAI
971507471257
——————————
——————————————-

[SUBASH KINATTERI PARAMBIL]

Any update from anybody for my query

——————————
SUBASH KINATTERI PARAMBIL
ACCOUNTS OFFICER
A.R Kanoo International School
BUR DUBAI
971507471257
——————————
——————————————-