Forum Discussion

Las's avatar
Las
Frequent Visitor
4 years ago
Solved

Calculation based on latest two dates

Hi Experts,   I have a date column which populates based on fortnightly basis ( Fortnightly is 14 days but I receive the data earlier ). My calculation should be based on Max(date) and the previous...
amitchandak's avatar
amitchandak
Super User
4 years ago

Las , Measures

 

Max date = maxx(allselected(Table), Table[Date])

 

2nd Max date = maxx(filter( allselected(Table), Table[Date] < [Max Date]) , Table[Date])

 

or

 

Max date = maxx(all(Table), Table[Date])

 

2nd Max date = maxx(filter( all(Table), Table[Date] < [Max Date]) , Table[Date])

Las's avatar
Las
Frequent Visitor
4 years ago

Hi Amit

 

Thanks for the prompt response.

2nd Max date, would this pick up 30/04 or 15/04?  Table[Date] < [Max Date] will search for the lowest and compared with the max date?

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Las , refer