Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
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
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
182 | |
85 | |
67 | |
61 | |
53 |