Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Dears,
I'm facing an issue that I appended 7 tables but when I check the data I found that amount duplicated without any reason although source file amounts aren't duplicated
Thanks
Solved! Go to Solution.
Hii @hanyfouda2023 ,
You might have appened the same table several times. I'd usually add a custom column named Source which value is anything that describes the sourc to each table that I append so I'd know where my numbers are coming from. This practice makes it easy to troubleshoot for errors.
Hii @hanyfouda2023 ,
You might have appened the same table several times. I'd usually add a custom column named Source which value is anything that describes the sourc to each table that I append so I'd know where my numbers are coming from. This practice makes it easy to troubleshoot for errors.
Dear Danextian,
Thanks for your reply , Could you please explain how to get this custom column , what is the dax measue to be added?
Thanks
Hi @hanyfouda2023 ,
It is a custom column in the query editor. In Add Column tab, go to custom column and create a Source column that indicates the source of your data. Do this for all the seven tables. Make sure to use the same column name for all of them.
Dear Danexitan,
Thanks I added the columns , and found which amount arent right. Do you have any idea how to solve it
Ì am not sure. Questions are:
Why are the amounts not right?
Did you append the several times?
What makes them being duplicated?
Why are the amounts not right? Yes its duplicated
Did you append the several times? Yes
What makes them being duplicated? I need to know why figuers not accurate
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
35 | |
34 |
User | Count |
---|---|
99 | |
56 | |
53 | |
44 | |
40 |