Forum Discussion

Turtledge's avatar
Turtledge
Regular Visitor
3 years ago
Solved

Error with DateTime.LocalNow in DateTime.Date

Hello everyone,

I have just started learning Power BI. I was using the DateTime.LocalNow function and my query is as the following:

let
Source = DimDate,
    TenYearsFromToday =
        Table.SelectRows(
           Source,
           each
          [FullDateAlternateKey] <= DateTime.Date(DateTime.LocalNow()) 
          [CalendarYear] >= Date.Year(DateTime.LocalNow()) - 10
       )
in
  TenYearsFromToday

 

and what I got was:

Expression.Error: We cannot apply field access to the type Date.
Details:
Value=10/25/2022
Key=CalendarYear

 

What does this error mean and how can I fix it ?

 

Need Help
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    3 years ago

    Turtledge,

     

    Try adding "and" between the two expressions in "each":

     

    let
Source = DimDate,
    TenYearsFromToday =
        Table.SelectRows(
           Source,
           each
          [FullDateAlternateKey] <= DateTime.Date(DateTime.LocalNow()) and
          [CalendarYear] >= Date.Year(DateTime.LocalNow()) - 10
       )
in
  TenYearsFromToday

     

1 Reply

  • DataInsights's avatar
    DataInsights
    Super User
    3 years ago

    Turtledge,

     

    Try adding "and" between the two expressions in "each":

     

    let
Source = DimDate,
    TenYearsFromToday =
        Table.SelectRows(
           Source,
           each
          [FullDateAlternateKey] <= DateTime.Date(DateTime.LocalNow()) and
          [CalendarYear] >= Date.Year(DateTime.LocalNow()) - 10
       )
in
  TenYearsFromToday