Days Between Last Date and Today

[Anonymous]

I have a data set with where items have multiple ship dates, I need to calculate the number of weeks between the last shipped date (most recent date) and today. I have tried datediff, creating custom measures, but I cannot seem to get it. Any help would be appreciated. 

[Anonymous]

Russ,

This is perfect! Thanks!

[RossEdwards]

Give this a try.  I didn't know your table's name, so i just called it "YourTable"

Shipped Days Ago = var itemNumber = SELECTEDVALUE('YourTable'[ITEM_NUMBER])
var lastDate = CALCULATE(
    MAX('YourTable'[SHIPPED_DATE]),
    ALL('YourTable'),
    'YourTable'[ITEM_NUMBER] = itemNumber
)
RETURN
DATEDIFF(Today(), lastDate, DAY)

[Anonymous]

Hey Ross,

I got this error:

[RossEdwards · Accepted solution]

Looks like "lastDate" is a reserved name.  We just need to change the variable name to something else.  Try this:

Shipped Days Ago = var itemNumber = SELECTEDVALUE('YourTable'[ITEM_NUMBER])
var lastDateVal = CALCULATE(
    MAX('YourTable'[SHIPPED_DATE]),
    ALL('YourTable'),
    'YourTable'[ITEM_NUMBER] = itemNumber
)
RETURN
DATEDIFF(Today(), lastDateVal, DAY)