Previous Available Date for Individual Products

[Anonymous]

Hi Everyone,

Can anyone help me how to create a dax formula to find "Previous Available" date for each "ID".
Date's are not continuiously existed for each ID (gaps in dates).

Please take the image as reference, for product "A" I supposed to get "sep 20/2022". Eventhough it is having 19th Sep as min date. 
Need to show the previous available day for each product

Thanks in advance

[davehus]

Hi @Anonymous ,

Swap FirstDate for PREVIOUSDATE and see if that works. 

Did I help you today? Please accept my solution and hit the Kudos button.