Forum Discussion
Sharing Variables between two sources
Hi Mic1979
Remove the square brackets around
Breakdown_Numbersin theNewstep:New = Table.AddColumn(#"Filtered Rows", "List", each {1 .. Breakdown_Numbers})A reference to another variable within a
letexpression doesn't require square brackets.With the square brackets,
[Breakdown_Numbers]was attempting to access a field namedBreakdown_Numberswithin the rows of#"Filtered Rows", which would work only if#"Filtered Rows"contained a column namedBreakdown_Numbers.See here:
Hi Mic1979
Remove the square brackets around Breakdown_Numbers in the New step:
New = Table.AddColumn(#"Filtered Rows", "List", each {1 .. Breakdown_Numbers})A reference to another variable within a let expression doesn't require square brackets.
With the square brackets, [Breakdown_Numbers] was attempting to access a field named Breakdown_Numbers within the rows of #"Filtered Rows", which would work only if #"Filtered Rows" contained a column named Breakdown_Numbers.
See here:
PERFECT!!
Thanks