Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
BrunieToons
Frequent Visitor

Problem merging on decimal data type

‎03-15-2022 07:28 AM

Does anyone know why about 10% of my records fail to join on this ID column, which is comes in from the data source as a decimal format? When I transform it to int, the join works. Here is the merge preview when both columns are in decimal format:

BrunieToons_0-1647354344232.png

 

Labels:
Message 1 of 2
1,215 Views
0
1 ACCEPTED SOLUTION
edhans
Community Champion
Community Champion

‎03-15-2022 07:51 AM

Change it to integer format first. Decimal has 15 level precision and since PCs are floating point, what looks like to you 3 might be 2.9999999999999 or 3.000000001. You've seen that in Excel.

merging on whole numbers will work fine.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

Message 2 of 2
1,204 Views
1 REPLY 1
edhans
Community Champion
Community Champion

‎03-15-2022 07:51 AM

Change it to integer format first. Decimal has 15 level precision and since PCs are floating point, what looks like to you 3 might be 2.9999999999999 or 3.000000001. You've seen that in Excel.

merging on whole numbers will work fine.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Message 2 of 2
1,205 Views

Helpful resources

Announcements
Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All