Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Everyone,
Sorry for my bad English. I got Table Revenue and Location as picture below.
When I merge 2 tables together revenue got duplicated. So I need column D so I can divine the number back to normal.
Please advice.
Solved! Go to Solution.
I have found the solution.
I user merge with aggregate then merge again to break it into details.
I have found the solution.
I user merge with aggregate then merge again to break it into details.
What is this, a DAX- or PQ-related question? If it's PQ, please find the forum on PQ.
If it's about DAX... then what do you mean by "merging tables"?
Thanks.
Best
Darek
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |