Forum Discussion
Testing date output validity
How can I test all the various Power BI date outputs to check if I'm using them valid/correct?
E.g. In SQL Server I can do SELECT getdate() and that will output the current date/time in the console.
2 questions here:
1) How can I do something similar in Power BI Desktop?
2) Is there a nice place that lists all the useful date formats in Power BI e.g., Start of current day, Start of current month etc etc.
4 Replies
Hi,
Are you looking for the Current Day ?
If yes, you could use the Today() in your code and also you could add the below code for the Current date and First day of the Month :
"TodayDate", TODAY(),"Start of Current Month",date(YEAR(TODAY()),Month(EOMONTH(TODAY(),0)),"01")Appreciate your KudosThanks but I'm looking to find out how to pass those as Paramters. I can creat the paramaters but how can I insert them into the query through advanced editor?
let Source = Sql.Database("DataBase1", "XXX", [Query="DECLARE#(tab)@return_value int#(lf)#(lf)EXEC#(tab) @return_value = [Reporting].[Report1]#(lf)#(tab)#(tab) @TimeZoneID = 1,#(lf)#(tab)#(tab) @TZStartDate = N'2022-09-01',#(lf)#(tab)#(tab) ---want to enter my start date parameter here @TZEndDate = N'2022-09-12',#(lf)#(tab)#(tab) -- want to enter my end date parameter here @DateType = 3#(lf)#(lf)SELECT#(tab) 'Return Value' = @return_value"]) in SourceAre you using the below code in PQ :
DateTime.LocalNow()
It is shown the current Date-Time
