Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have created two parameters:
StartDateParam = 1/1/2022
EndDateParam = 3/5/2024
I have the following M code to pull in a stored procedure into Power BI:
let
StartDate = Text.From ( StartDateParam ),
EndDate = Text.From ( EndDateParam ),
Source = Sql.Database("S-DB2-VMC\VERSOVA_PROCDATA", "EggProcPlant_Test",
[Query="EXECUTE [dbo].[sp_Gp_GrdEggSalesComb]#(lf) @Startd = '" & StartDate & "'#(lf) , @Endd = '" & EndDate & "'"])
in
Source
Works great...however, I would like to have the EndDateParam always use today's date so I don't have to manually update the parameter each time. How would I do that?
Solved! Go to Solution.
i dont get, why you want to put it in the current value .
i meant go to advanced edior
and change the m code for the following line .
let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠:
please try this :
EndDateParam = Text.From(DateTime.Date(DateTime.LocalNow()))
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Thank you for the quick response! Unfortunately, I get the following error: DataSource.Error: Microsoft SQL: Error converting data type varchar to datetime.
How do I put that formula into the Parameter editor? I tried the attached screenshot, but it did not work (produced the error above)
i dont get, why you want to put it in the current value .
i meant go to advanced edior
and change the m code for the following line .
let me know if this helps /
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠:
Got it...thank you!! I appreciate the help!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |