Forum Discussion
YavuzDuran
Helper III
Helper IIIPrevious N Month - Commission Calculation
Hi All,
I am trying to calculate a selected month's commission. So I need the previous N months sales #
Let's say I will calculate May Commission, so I will need Feb+Mar+Apr Sales (previous 3 months' sales, not including the commission month)
Can you please help me?
YavuzDuran , try a measure like
Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-1) ,-3,MONTH))
1 Reply
- amitchandak
Super User
YavuzDuran , try a measure like
Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-1) ,-3,MONTH))