Forum Discussion

RoseyAlexa's avatar
RoseyAlexa
Helper I
3 years ago

Billing Total from another table

Can anyone help find the errors in this code?

 

= Table.AddColumn(#"Changed Type", "BillingTotal", each
let
projectID = [Project_ID],
fees = if Table.SelectRows(ForecastBilling, each [ID_Project] = projectID)[Unweighted Fees] <> null then List.Max(Table.SelectRows(ForecastBilling, each [ID_Project] = projectID)[Unweighted Fees]) else 0
in
if fees > 0 then "Billing" else "Pipeline"
)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    What error are you getting?