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.
Hi,
I hope your are well.
I have two table :
First article base :
second sales :
In the article base, I would like to display the sum of sales for each article. Can someone help me please ?
Thank you in advance.
JL6
Solved! Go to Solution.
Hi,
depends if there is a relationship between tables.
If exists - simply add new column as
@JonasBDM you just need to create relationship between these two tables on ART columns of both tables. then you use the ART column from the first table and QTE from the second table in the matrix visual. you will get sum by ART. there is no need to create any measure but relationship between tables will do the job. thanks
Proud to be a Super User!
@JonasBDM you just need to create relationship between these two tables on ART columns of both tables. then you use the ART column from the first table and QTE from the second table in the matrix visual. you will get sum by ART. there is no need to create any measure but relationship between tables will do the job. thanks
Proud to be a Super User!
Hi,
You could use a dax function to add a new column called Sum of Sales to the Article table.
Hi,
depends if there is a relationship between tables.
If exists - simply add new column as
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |