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.
Hi Stephen,
Thank you for your reply but unfortunately the current date isn't what I am looking for. I need to create a variable which I can type the report date in (This could be a date in the past). Then I can use this variable or object to refer to in my table of 6,000 rows to perform the necessary calculations.
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.
Thanks for that Stephen that worked!