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.
Super UserMake a named range in Excel that refers to the report run date. You can access this named range inpiwerquery as a separate query. You may want to transform it a bit depending on how you want to use it. Assuming you transform it to produce just the actual date value, you can use the name of your query anywhere you want the report run date.
Hi thanks for your reply,
So i have made a named range in excel called 'Report_Date' which refers to cell B2 the date (22/07/2024). But how do i refer to that variable in power query?
