Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Measure getting corrupted with appending two tables

Hi,

 

I have two source tables, one from one ERP system and one from the legacy ERP system. I have aligned all the columns with same name to be able to append the legacy table to the other one. When checking the figures in the only measure both tables are correct but after I append the legacy table the measure get changed. It is small differences but still. I figured it could have something to do with the precision of the data type but all fields are in decimal.

 

Have anyone encountered this problem?

 

Rgs,

//Patrick

Status: Needs Info
Comments
v-haibl-msft
Employee

@PatrickB

 

I cannot repro the same issue on my side (but I'm not getting data from ERP system). What is the formula of your DAX measure? How does your measure get corrupted? Is there any error message?

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
Anonymous
Not applicable

need to use SELECTCOLUMNS and enforce order of columns from the different tables, otherwise the UNION will combine them with errors