Forum Discussion

Sachintha's avatar
Sachintha
Icon for Helper III rankHelper III
4 years ago

Filter a table with DateTime by a Date slicer

I have a table with a DateTime column and a few other columns, say, { ID, Unit, and DateTime }. I'm including the raw data at the bottom of the post here.   After importing this CSV to Power BI, I'...
Need Help
Show and Tell
Tips and Tricks
Sachintha's avatar
Sachintha
Icon for Helper III rankHelper III
4 years ago

I still need the DateTime to be DateTime, since I need to use the time in other charts in my report.

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi Sachintha , You could use DateTime.Date(datetimecolumn) in powerquery and extract the date and join to your data table. That way, you retain your datetime for other charts.

 

Did I help you today? Please accept my solution and hit the Kudos button.