Forum Discussion
How can I filter data from datetime to datetime?
Dears, I have the question that you can see in the subject - How can I filter data from datetime to datetime?. I want to filter date from YYYY-MM-DD HH:MM to YYYY-MM-DD HH:MM. Is it possible? I have...
I want to make filters using this:
In the Query editor you can goto the filter icon on the column header. Select the Date/Time Filters menu and then custom
You can then add a range.
The M code looks like this
#"Filtered Rows" = Table.SelectRows(#"Expanded Executables", each [StepEnd] >= #datetime(2017, 10, 17, 19, 45, 0) and [StepEnd] < #datetime(2017, 10, 17, 19, 55, 0))
in
#"Filtered Rows"Against a page/report or visualisation you can use the advanced filtering
I don't know an easy way of doing slicers to filter datetimes.
Phil
pxg08680 how can I do that?
Even tought you get time field from all date time fields, how can you filter the data..?
The above datetime has some time values. Does your data contain the same for previous day also.
