Forum Discussion
Salesforce source change
I was able to change the source by changing the advance editor, however, I have a problem in the following step.
This is the original text code I had:
Initial code:
Let
Source = Salesforce.Reports(),
#"00O1o000004gOEjEAM" = Source{[Name="00O1o000004gOEjEAM"]}[Data],
#"Expanded CV (converted)" = Table.ExpandRecordColumn(#"00O1o000004gOEjEAM", "CV (converted)", {"amount", "currency"}, {"CV (converted).amount", "CV (converted).currency"}),
#"Expanded Weighted CV (converted)" = Table.ExpandRecordColumn(#"Expanded CV (converted)", "Weighted CV (converted)", {"amount", "currency"}, {"Weighted CV (converted).amount", "Weighted CV (converted).currency"}),
#"Added Date.StartOfMonth" = Table.AddColumn(#"Expanded Weighted CV (converted)", "Date.StartOfMonth", each Date.StartOfMonth([Contract Sign Date])),