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
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.
@Paulyeo11 , Please find the attached file after signature
@Paulyeo11 , Please find the attached file after signature
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
150 | |
118 | |
111 | |
106 | |
95 |