Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 is a date. I need to subtract the number of days that is my lead time from the expiration date. So if the lead time is ten days and the expiration date is 9/18/22, I need the new column to populate with the date 9/8/22. Is there a way to do this using DAX?
Thanks in advance!
Solved! Go to Solution.
Yes @kmlcoch , 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 @kmlcoch , you can change the interval dynamically. Try this:
Result = DATEADD([Expiration Date].[date], lead-time, DAY)
That worked! Thank you so much
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |