Forum Discussion
DATEADD and Sum
Hello,
I am trying to write a DAX formula to calculate a quantity of items I will receive at a future date.
Based on a ship date for a list of items, we want to say that 80% of them will be returned to us 30 days in the future.
I have the date add part of the DAX: DATEADD( 'DAYSTABLE'[DAYS],30,DAY) , but I am not sure about how to calculate the 80% of the quantity shipped of the original date.
Does anyone have any ideas, or have done something like this previously? Thanks so much in advance!
2 Replies
Riley-Byrne I believe your full measure is somethign like this
Future Qty = CALCULATE ( SUM ( Table[Qty] ), <your date add calculation> ) * .80
Multiply your measure .80 to get you 80% of qty.
Hi Riley-Byrne ,
Please illustrate your requirement with sample data and desired output.
How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
