Calculating Number of Days to expiry, per lot

[AdamD123]

Hello,

I have used this forum many times for help but this is my first post as I am unable to see my issue, so hopefully someone can help me!

I am trying to calculate the number of days from an items expiry date, to today.  Each item, has multiple entries by 'Lot No.' and the days to expiry count is only taking into account the latest.

For example:

Item X has two lots:

• LOT01 with an expiry 01/01/2025
• LOT02 with an expiry 01/01/2026

Days to expiry (as of 01/05/2025) should show as:

• LOT01 - 245
• LOT02 - 620

However, it is only showing as the latest expiry:

• LOT01 - 620
• LOT02 - 620

I am using a new colum "=ItemLedgerEntries[expiration_date].[date]-today()"

Data is imported from Business Central.

Any help is greatly appreicated!

Thank you,

Adam

[Greg_Deckler · Accepted solution]

@AdamD123 That's a bit strange. Perhaps try this variation first:

Column = ( [expiration_date] - today() ) * 1.

Otherwise, perhaps this measure:

Measure = ( MAX( 'ItemLedgerEntries'[expiration_date] ) - today() ) * 1.

[AdamD123]

@Greg_Deckler Hi Greg, the Column did not work but the measure did! Thank you so much for the quick reply and solution.