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.
Hello,
My table is called "Sales".
Each invoice is divided into different invoice lines. I would like to add a column with a formula that would enable me to aggregate the amounts of the invoice lines according to the invoice number to which they are attached.
Example: this new column would display for the first two lines the amount 5 because 2+3+6 = 11 = total amount of invoice A.
Can you help me please ? Thank you so much!
Solved! Go to Solution.
hi @rico_o_o
are you expecting a calculated column like below:
column =
SUMX(
FILTER(
sales,
sales[Invoice_number]=EARLIER(sales[Invoice_number])
),
sales[Amount(in euro)]
)
hi @rico_o_o
are you expecting a calculated column like below:
column =
SUMX(
FILTER(
sales,
sales[Invoice_number]=EARLIER(sales[Invoice_number])
),
sales[Amount(in euro)]
)
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 |
---|---|
49 | |
26 | |
19 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |