Forum Discussion

Turtledge's avatar
Turtledge
Regular Visitor
4 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.Se...
Need Help
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    4 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

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 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