Power M Error (Expression.Error: The number is out of range of a decimal value.)

[Anonymous]

I am trying to merge 2 tables as new.  Both tables have a unique identifier:

Unique ID: (Project ID_Bill Code)

PR20003713_00000052

When i perform a right outer Merge between the two i get the following error:

Expression.Error: The number is out of range of a decimal value.
Details:
NaN

Please let me know if anyone can assist!

[v-yingjl]

Hi @Anonymous ,

Before you merge tables, you can sort the column by desc or asc to try to find the value which has been out of the range of decimal value. You can share some sample data or screenshots for further discussion.

Best Regards,

Yingjie Li