Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

 

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

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
    speedramps
    Icon for Super User rankSuper User
    5 years ago

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

    There is no Book1 or Book2 table