Forum Discussion
Trouble With Links/Formulas
I have two tables. The first table is a list of containers, charge codes and amounts. See sample table with charges totalling 1400. The second table is a list of containers, order lines ...
X3svfdB1HOjKYc0 , Merge these two tables in power Query
: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
a new column in DAX =
divide([Amount] , sumx(filter(Table, [Container $] = earlier( [Container $]) && [Charge] = earlier( [Charge]) ), [Volume] ))