Forum Discussion

enocperez's avatar
enocperez
Frequent Visitor
10 years ago

Calculates MTD with New Measure

I want to get a New Measure and I get an errros all the time what am I doing.   Sales MTD =CALCULATE( [Sales], PARALLELPERIOD('Item Sales'[Date Of Business], -1,MONTH))  
enocperez's avatar
enocperez
Frequent Visitor
10 years ago

Ok I have made the update and still I get an issues with the Calculation.  

 

 

 

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

You need to read the error messages you get. They normally tell you what the problem is. Your error says there are too many arguments for the sum function. That is a hint that you have missed a round bracket after the square bracket in sum. 

 

Also, by the way, the PARALLELPERIOD looks wrong too.  I would first write current MTD using TOTALMTD

Total Sales MTD = TOTALMTD(sum('item sales'[sales]),calendar[date])

and then a version for MTD prior period like this 

=calculate([Total Sales MTD],datesadd(calendar[date],-1,month))

 

as Sean said, you also need a calendar table.  You can read about that in my knowledge base http://exceleratorbi.com.au/power-pivot-calendar-tables/