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, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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