Forum Discussion

smko's avatar
smko
Icon for Helper I rankHelper I
5 years ago
Solved

Allocation of header table into detail table

I want to allocate the discount amount happened at the invoice level into line item evenly. Basically the discount will spread evenly into each item, for example InvoiceID 1 has 2 items, hence 20/2 =...
Need Help
smko's avatar
smko
Icon for Helper I rankHelper I
5 years ago

Thanks Fowmy! I'm new to M, could you explain the meaning of (x)=> and the "x" in front of [Discount] and [InvoiceID]?

 

(x)=> 
    x[Discount]/
    List.Count(
        List.Select( #"Merged Queries"[InvoiceID] , each _  = x[InvoiceID])
    )