Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
91 | |
87 | |
84 | |
68 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |