Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Las
Frequent Visitor

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 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

1 ACCEPTED SOLUTION

@Las , refer

 

amitchandak_0-1651644408730.png

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
Las
Frequent Visitor

Thank you. All good. 

amitchandak
Super User
Super User

@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])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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?

@Las , refer

 

amitchandak_0-1651644408730.png

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.