Forum Discussion

Morton041740's avatar
Morton041740
Frequent Visitor
7 years ago
Solved

DATEADD contiguous date error

I am working with a stock inventory report and would like to add a what if parameter to allow the report user to pick a number of days by which they change the stock expiry date either positive or ne...
  • Anonymous's avatar
    Anonymous
    7 years ago

    Morton041740 -

    A couple troubleshooting possibilities:

    1. Does the calendar table have any gaps?

    2. Try using expiry date as the Enabled relationship and see whether a simpler version of the measure works.

    Hope this helps,

    Nathan