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 retu...
parry2k
Super User
Super UserRiley-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.