Forum Discussion
Create a date Variable in excel and get power query to repeat that date over all rows in a table
Hi Jimbo1980 ,
After I reviewed again, I understand that you want call a column from another table.
Try adding a custom column. #"tablename"[columnname].
#"Table (2)"[ReportDate][RpoertDate] is in Table(2).
Expand it.
You can see the [ReportDate] from Table(2) now is in Table.
Similar post:Solved: How to reference another table in Query Editor (M) - Microsoft Fabric Community
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't have access to my laptop at the moment. But ...
- Make a new empty query.
- Enter the formula Excel.CurrentWorkbook()
- This will show you all the accessible content
- Find your named range
- Click on the value in the content column
- If it appears as a table, you may need to drill down until it just goes the date.
Give you query a name and you can use it in any expression...
so i have managed to add the report date as a query, I have drilled down. The reference for the date in power query appears to be '= #"Changed Type"{0}[Column1]'. But then if I go into another query how do i reference this report date query?