The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Oi.
Tenho uma tabela com informações de pedidos e outra referente aos lançamentos de NFs dos pedidos, gostaria de criar uma coluna na tabela de pedidos com a soma das na tabela de NFs pois existem várias NFs referentes a um pedido.
Solved! Go to Solution.
Hi @Greg5 ,
I think your tables should look like as below.
Orders:
Invoice:
Here are two workarounds to achieve your goal.
1. Create an active relationship between two tables by [Orders] columns.
Sum of Invoice = CALCULATE(SUM(Invoice[Invoice]))
Result is as below.
2. If you don't want to create a relationship or you want to inactive the relationship between two tables, try this code.
Sum of Invoice = CALCULATE(SUM(Invoice[Invoice]),FILTER(Invoice,Invoice[Orders] = EARLIER(Orders[Orders])))
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Greg5 ,
I think your tables should look like as below.
Orders:
Invoice:
Here are two workarounds to achieve your goal.
1. Create an active relationship between two tables by [Orders] columns.
Sum of Invoice = CALCULATE(SUM(Invoice[Invoice]))
Result is as below.
2. If you don't want to create a relationship or you want to inactive the relationship between two tables, try this code.
Sum of Invoice = CALCULATE(SUM(Invoice[Invoice]),FILTER(Invoice,Invoice[Orders] = EARLIER(Orders[Orders])))
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
82 | |
82 | |
37 | |
34 | |
32 |
User | Count |
---|---|
94 | |
79 | |
61 | |
51 | |
51 |