Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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))