Power Query: Custom Column, reference specific value from another query

[mrandall86]

Hi,

I have a query called IntroWindow with a date for 'HireDateFrom':

I want to be able to reference that for a custom column in the CurrentHeadcount query. I thought it would be something like the example below but, it isn't. Help would be greatly appreciated.

Thanks

[mrandall86]

Absolutely correct - thank you 🙏

[lbendlin · Accepted solution]

the # sign is used in combination with double quotes.  You don't need that in your case as IntroWindow has no characters that need protecting.  Remove the #.