topic Re: Calculation based on latest two dates in DAX Commands and Tips

Calculation based on latest two dates

Las — Wed, 04 May 2022 04:39:02 GMT

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 day that is available.

Example:

Date received
15/04/2022
30/04/2022
12/05/2022

From the above dates, how do i select 30/04/2022 and 12/05/2022 only? and for the next month also the logic should work
the same way like selecting 12/05/2022 and 30/05/2022 (Future date, which is currently not available) automatically.

This might be an easy one but appreciate your help.

Thank you.

Las

Re: Calculation based on latest two dates

amitchandak — Wed, 04 May 2022 05:31:22 GMT

Las , Measures

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

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

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

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

Re: Calculation based on latest two dates

Las — Wed, 04 May 2022 05:43:52 GMT

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?

Re: Calculation based on latest two dates

amitchandak — Wed, 04 May 2022 06:06:56 GMT

Las , refer

Re: Calculation based on latest two dates

Las — Wed, 04 May 2022 06:09:24 GMT

Thank you. All good.