Case 983 How to append 2 Table into 1 when i cannot make both table cal field name same ?

[Paulyeo11]

Hi All

I just try to append 2 company data file , i face into problem , the calulation field name for both table cannot be having same field name. may i know how you solve the issue ?

Below is my data file 1 , i create a Measure :-

Below is my data file 2  , I also create the Measure :-

I am not able to rename Measure 2 to Measure , because Measure field name already used.

As i need to append these 2 table into one. Any suggestion.

Remark :-

https://www.dropbox.com/s/k9gui2ndltu9km5/PB_TDS_V026.pbix?dl=0

My actual PBI file , consisit of many field , i cannot append both file into one , then do recode the field , as one file is from SAP another file is from SYSPRO , i need to clean up the data an make all field name same and append into one.

Paul

[amitchandak · Accepted solution]

@Paulyeo11 , Please find the attached file after signature

[Paulyeo11]

Hi Amit

Great you able to combie both table into 1 , But the field for sales amount now created 2 different field , it there a way to make it into one ? so that my YTD can applied for Both table .

i mean it there at way to shift the 2 amount column into one , i refer to using one sales amount field for both table. using some expression to move the book 2 table amount to Book 1 table amount.

Hope you can share with me

Paul

[speedramps]

Thanks for the Pbix example. Which 2 tables are trying to append? 

There is no Book1 or Book2 table

[Paulyeo11]

Hi Sir

Sorry i forget file attach the book 1 and book 2 , See the below link :-

https://www.dropbox.com/sh/ximuzth7wvrr5ms/AABPgnwjK8oSxzUcZ5oJio5aa?dl=0

Paul