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)
Hi Anonymous ,
Try using DATEADD()
Eg- Result = DATEADD([Expiration Date].[date], -10, DAY)
Anonymous -> Please hit the thumbs up & mark it as a solution if it helps you. Thanks.
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