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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Paulyeo11
Impactful Individual
Impactful Individual

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

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 :-

Paulyeo11_2-1605477293438.png

 

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

 

Paulyeo11_3-1605477370103.png

 

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Paulyeo11 , Please find the attached file after signature

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Paulyeo11 , Please find the attached file after signature

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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
Super User
Super User

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

There is no Book1 or Book2 table

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

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.