Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)]
)
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |