Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

M dates

Hi, 

How I do in power query write out previous year to date? 

 

I have a Year to date flag using date.isinyeartodate(app_date). I just want the same thing but for last year. Any ideas please? 

Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Date.IsInCurrentYear(
    Date.AddYears(  [app_date],1)
     ) = true and  [app_date] <=  Date.AddYears(Date.From( DateTime.LocalNow()),-1)

4 Replies

    • M_SBS_6's avatar
      M_SBS_6
      Helper V
      2 years ago

      Thanks. This gives me the whole of last years view but I need last years year to date

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    pls try this

    Date.IsInCurrentYear(
    Date.AddYears(  [app_date],1)
     ) = true and  [app_date] <=  Date.AddYears(Date.From( DateTime.LocalNow()),-1)

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    and try this

    [
 t1 = 
 Date.AddYears(Date.From( DateTime.LocalNow()),-1),
 t2 = Date.StartOfYear(t1),
 Result = [app_date]>= t2 and [app_date]<=t1][Result]