Share via

We cannot convert the value #datetime(2021, 12, 30, 0, 5, 32.69) to type function

Andrew Mason 21 Reputation points
2021-12-31T22:56:19.457+00:00

I am trying to to have a dynamic filter that pulls every set up after 5:00 PM from the day before with little luck. Here the relevant part of the code:

 #"Changed Type" =

Table.TransformColumnTypes(#"Sorted Rows",{{"Driver ID", type datetime}}),
#"Filtered Rows3" = Table.SelectRows(#"Changed Type", each DateTime.From([Driver ID]) > Date.AddDays(DateTime.From(Driver ID), -1))
in
#"Filtered Rows3"

Community Center | Not monitored
0 comments
Accepted answer
  1. Anonymous
    2021-12-31T23:02:49.777+00:00

    Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
    https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

    --please don't forget to Accept as answer if the reply is helpful--

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.