Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"
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
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.
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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.