add custom column based on another query

[rjmdc]

hi
i have a table of names and purchases
i have another query drilled down to a parameter called sevicemonth - this is manually changed as necessary
how do i add a column with service month and the date i have as servicemonth merged in to the names purchases query
isit possible?

 

[rjmdc]

Services sample.xlsx
	A	B
1	Reporting Month	7/1/2022
2
Variables

this is the query that creates service month
can i populate services with this servicemonth based on need

 

[rjmdc]

its ok i figured it out
i did a custom column and refered to the data as #"ReportingMonth"

 

[jdellasala]

Services sample.xlsx
	A	B
1	Reporting Month	7/1/2022
2
Variables

this is the query that creates service month
can i populate services with this servicemonth based on need

Where does the date come from? There is NOTHING in the Table in your Response #9 with anything even implying a date. How is the date in B1 determined from the data in #9? Is "Reporting Month" data or a label, and if it's a label why is it to the left instead of as a column header?

 

[rjmdc]

i figured it out
thanks