Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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:
Days to expiry (as of 01/05/2025) should show as:
However, it is only showing as the latest expiry:
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
Solved! Go to 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 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.
@Greg_Deckler Hi Greg, the Column did not work but the measure did! Thank you so much for the quick reply and solution.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |