Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Max and Min date

Hi,   I am trying to create identify with 1 and 2 the Max and Min date (1=Min and 2=Max).   Table2: Month          Order April 2023        1 May 2023         2   Preferly in Power Query 
Need Help
Show and Tell
Tips and Tricks
Ahmedx's avatar
Ahmedx
Super User
3 years ago

or try this

let 
     YearNow =  Date.Year( DateTime.LocalNow()),
    MonthNow =  Date.Month( DateTime.LocalNow()),
    date1 =#date(YearNow,MonthNow-2,1) ,
    date2 =#date(YearNow,MonthNow-1,1) ,
    date3=  #date(YearNow,MonthNow,1)  ,
    Source = #table(type table [Month=date, Order=Int64.Type], 
                          {
                              {date1,1},{date2,2},{date3,3}
                               })
in
    Source