Forum Discussion
Need to calculate values between 2 dates dynamically
Hi, I have had production values since 2017. as of the date I want to calculate matured product production total based on the product warranty. example: Mfg. Month & Year Mfg. Qty (N...
Dear lbendlin,
Thanks for your input.
but I need Dax to calculate the production & return quantity based on the dates. not total warranty %
like: if my product warranty matured till Apr'21 I need to calculate the total from apr'21 to back wards & extract the return percentage from it .( I will do Edate formula in excel & sum commutative from that date to backdated )
the mature warranty date varies from product to product which I have in another table.
I tried dates between & dateadd but couldn't get exact results.
lbendlin
Super User
Super UserYour date slicer already does all the work for you. You can adjust the measure I posted to show the individual sums, or use implicit measures.