How can I filter data from datetime to datetime?

Question

Dears,I have the question that you can see in the subject -&nbsp;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 to show car routes history on the map and I need it.&nbsp;I please you also to send me instruction for other filter ways if descibed above is not possible.&nbsp;Thank you.

kowalewski92 · Answer

I want to make filters using this:&nbsp;

pxg08680 · Answer

kowalewski92May be I didnot get you exactly. Do you want to filter the data based on DATETIME field..?You can drop the column into a slicer directly or create a column.

stretcharm · Answer

In the Query editor you can goto the filter icon on the column header. Select the Date/Time Filters menu and then custom&nbsp;You can then add a range.&nbsp;&nbsp;The M code looks like this&nbsp;    #"Filtered Rows" = Table.SelectRows(#"Expanded Executables", each [StepEnd] &gt;= #datetime(2017, 10, 17, 19, 45, 0) and [StepEnd] &lt; #datetime(2017, 10, 17, 19, 55, 0))
in
    #"Filtered Rows"Against a page/report or visualisation you can use the advanced filtering&nbsp;&nbsp;I don't know an easy way of doing slicers to filter datetimes.&nbsp;Phil

kowalewski92 · Answer

stretcharm&nbsp;I want to get time here. Is it possible? I am beginner in Power Bi.. :)&nbsp;

kowalewski92 · Answer

pxg08680&nbsp;how can I do that?

Forum Discussion

How can I filter data from datetime to datetime?

8 Replies

Related content

Converting Epoch Datetime into regular datetime format

Filter by DateTime in Odata

Convert DateTime to Date

MAX datetime truncates to date???

datetime difference in datetime format