Power Query Formula

[dtango9]

Hi!

In column AT I'm looking to create a formula that calculates totals from a different table (Leads) that is connected to this query since column AM on the current table?  Any help?  

This is how "L12 Leads" column was created:
let
Source = Sql.Databases,
BI = Source{[Name="BI"]}[Data],
dbo_TrueTradeLeadSummaryPlus = BI{[Schema="dbo",Item="TrueTradeLeadSummaryPlus"]}[Data],
#"Added Custom" = Table.AddColumn(dbo_TrueTradeLeadSummaryPlus, "L12 Leads", each [CurrentMonth]+[CurrentMonthMinusOne]+[CurrentMonthMinusTwo]+[CurrentMonthMinusThree]+[CurrentMonthMinusFour]+[CurrentMonthMinusFive]+[CurrentMonthMinusSix]+[CurrentMonthMinusSeven]+[CurrentMonthMinusEight]+[CurrentMonthMinusNine]+[CurrentMonthMinusTen]+[CurrentMonthMinusEleven])
in
#"Added Custom"

[v-juanli-msft]

Hi @dtango9 

I'm not very clear about your requirement.

What final result would you like?

the formula seems to sum some columns, are they from the same table?

if not, what relationship among different tables?

Best Regards

Maggie

[camargos88]

Hi @dtango9 ,

Check if Power Query is pushing this new column through the database using Folding Query, if yes it's possible that if you have null values, when you combine them you get null as return.

[Anonymous]

Hi @dtango9 ,

I'm not sure understood (all) the problem(s) you have. But you can start by trying to change the formula in this way(the reference to other table is missing probably):

#"Added Custom" = Table.AddColumn(dbo_TrueTradeLeadSummaryPlus, "L12 Leads", each Leads[CurrentMonth]+Leads[CurrentMonthMinusOne]+and so on ...
in
#"Added Custom"