Show most recent date

[Anonymous]

I need to create a measure that shows the next shipment date in the dataset. For example my next shipment date is April 25th. When I add Shipment date to my visual it only allows me to see the earliest and the latest but never the next. 

[johnt75 · Accepted solution]

You could create a measure like

Next shipment date = CALCULATE( MIN('Table'[Shipment date]), 'Table'[Shipment date] >= TODAY())