Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Mic1979
Post Partisan
Post Partisan

Sharing Variables between two sources

Dear all,

 

I have the following code:

let
Source1 = OVERALL_DISTRIBUTION,
#"Filtered Rows" = Table.SelectRows(Source1, each ([Integrated_Check_Valve] = "Integrated Check Valve NO") and ([Connection_Type_Front_Port] = "Female Thread") and ([Voltage] = "24VDC") and ([Valve_Function] = "Collector") and ([Sealing_Material] = "FPM") and ([Pipe_Size_Front_Port] = "1/2 inch")),

Source2 = Component_List,
Name_Column = Source2 [Name],
Breakdown_Numbers = List.Count (Name_Column),

New = Table.AddColumn(#"Filtered Rows", "List", each {1..[Breakdown_Numbers]})

in New

 

As you can see, my target is to use the variable Breakdown_Numbers (related to the source 2) to add a column List in the Source1.

 

However I got the following error:

Expression.Error: The field 'Breakdown_Numbers' of the record wasn't found

 

I think this is something related to the variable delcaration, but I am not very familiar with the topic.

 

Hoping you can support.

 

Thanks.

1 ACCEPTED SOLUTION
OwenAuger
Super User
Super User

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:

https://bengribaudo.com/blog/2018/10/30/4644/power-query-m-primer-part10-types-list-record#field-acc...

 

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

View solution in original post

2 REPLIES 2
OwenAuger
Super User
Super User

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:

https://bengribaudo.com/blog/2018/10/30/4644/power-query-m-primer-part10-types-list-record#field-acc...

 

 


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
LinkedIn

PERFECT!!

 

Thanks

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.