Forum Discussion
speedramps
Super User
Super UserPower BI calendar batch date
I want to pass a ETL batch date from my data warehouse to my Power BI calendar. I know how to hard code a Power BI calendar, but how can I replace the hardcoded CurrentDate = #date(2020, 1, 1) with...
I would create a new blank query and call it something like: param_CurrentDate
From there you can have in your code something like this:let // Substitute Table[Date] to your query table you'd like to retrieve from and the column in which holds the current date CurrentDate = List.Max(Table[Date]) in CurrentDate
And, finally, you can call param_CurrentDate from your calendar query.
hnguy71Super User
Super UserI would create a new blank query and call it something like: param_CurrentDate
From there you can have in your code something like this:
let
// Substitute Table[Date] to your query table you'd like to retrieve from and the column in which holds the current date
CurrentDate = List.Max(Table[Date])
in
CurrentDate
And, finally, you can call param_CurrentDate from your calendar query.
speedrampsSuper User
Super UserThank yoi hnguy71. Yes that is!