Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Minimum Product Date with Batch

Dear Along with greeting you, I would like to request your collaboration in a dilemma that blows my mind and I have not managed to solve. I am trying to find the closest date to expire per p...
v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi Gsv 

 

You can try this measure

Closest date to expire =
CALCULATE (
    MIN ( Stock[FechaVcto] ),
    ALLSELECTED ( 'Stock'[Lote] ),
    Measurement[Stock] > 0
)

Or

Closest date to expire =
CALCULATE (
    MIN ( Stock[FechaVcto] ),
    ALLEXCEPT ( 'Stock', 'Stock'[Producto], 'Stock'[GLOSA] ),
    Measurement[Stock] > 0
)

 

If they don't work, can you please provide some mock data to show the tables as well as relationships among tables? 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.