Forum Discussion
DAX Formula Help
I am trying to figure out how to subtract a number from a date. For further context, I have a "Lead-Time" column and I have a "Expiration Date" column. Lead-Time is a whole number and expiration date...
Yes Anonymous , you can change the interval dynamically. Try this:
Result = DATEADD([Expiration Date].[date], lead-time, DAY)
Is there a way to put the column in the second array instead of the number? otherwise it would all be manual
Yes Anonymous , you can change the interval dynamically. Try this:
Result = DATEADD([Expiration Date].[date], lead-time, DAY)
That worked! Thank you so much