Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Days Between Last Date and Today

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Anonymous
Not applicable
2 years ago

Hey Ross,

 

I got this error:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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)