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.
Hello,
Could anyone help me to fix an issue how to set query in order to get records between specific date time range? I need to change range dynamically:
start of range: (currentYear, currentMonth, currentDay - 1, 6,0,0)
end of range:(currentYear, currentMonth, currentDay, 6,0,0)
At pic is only end filteration range. How is it possible to modify this query in orrder I could use dynamic variables in query?
I tried this but it didn't work:
= Table.SelectRows(#"Renamed Columns", each [Created] <= #datetime(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()),6,0,0))
RB,
MWD
Solved! Go to Solution.
@MWD,
You may refer to the code below.
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Created] > DateTime.From(DateTime.Date(DateTime.LocalNow())) + #duration(-1,6,0,0) and [Created] <= DateTime.From(DateTime.Date(DateTime.LocalNow())) + #duration(0,6,0,0))
@MWD,
You may refer to the code below.
#"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Created] > DateTime.From(DateTime.Date(DateTime.LocalNow())) + #duration(-1,6,0,0) and [Created] <= DateTime.From(DateTime.Date(DateTime.LocalNow())) + #duration(0,6,0,0))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
99 | |
73 | |
65 |