Forum Discussion

sagadgreat's avatar
sagadgreat
Icon for Helper I rankHelper I
6 years ago
Solved

Tracking sales vs. returns made in consecutive months

I have a table where there are sales vs. returns made in consecutive months anda  formula that is calculating total extended sales.    If I put both months in using the positive and negative qtys (...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    I did not get it completely. But do you want to combine this month's sales with next month's return? you can have formula's like

     

    MTD complete Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH('Date'[Date])))
next MTD (complete) return =  CALCULATE(SUM(Return[Return Amount])*-1,DATESMTD(ENDOFMONTH(dateadd('Date'[Date],1,MONTH))))
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi sagadgreat 

Is this problem sloved? 
If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly?
If not, please feel free to let me know.
 
Best Regards
Maggie