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.
I have the first table like this
second table
I want the second table to be grouped by Customer and add it's paid_amount to first table as column
as below
Thank you
Solved! Go to Solution.
@Anonymous , A new column in first table
if they are realted ,
sumx(relatedtable(second), second[paid amount])
if not
sumx(filter(second, first[cutomer] =second[customer]), second[paid amount])
refer: https://www.youtube.com/watch?v=czNHt7UXIe8
Power query merge can also help : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@Anonymous ,
I replicated your sample at my side and got the expected result. Attaching PBIX file for your reference.
@Anonymous , If your both table connected properly with each other based on Customer Column so you dont need anything. Just drag all three columns in the single table visual.
You can see below two screen shots:
@Anonymous , A new column in first table
if they are realted ,
sumx(relatedtable(second), second[paid amount])
if not
sumx(filter(second, first[cutomer] =second[customer]), second[paid amount])
refer: https://www.youtube.com/watch?v=czNHt7UXIe8
Power query merge can also help : https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Thank you for reply.
sumx(filter(second, first[cutomer] =second[customer]), second[paid amount]) I have used this one since tables are not related. Is that possible to add another date filter to second table like ,
second[Date] = eomonth(today(),-1)+1 ?
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |