Forum Discussion

abc_777's avatar
abc_777
Icon for Solution Specialist rankSolution Specialist
5 years ago

need to understand

Dear Concern,   I have a very simple query to understand   when i create a global calendar then using PARALLELPERIOD( BMCalendar[Date], -1, MONTH   My query is when i change global calend...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi abc_777 ,

 

In my sample data, I created the following measures, and they all returned the correct results.

PARALLELPERIOD_BM = 
CALCULATE(
    SUM(BMCalendar[value]),
    PARALLELPERIOD( BMCalendar[Date], -1, MONTH)
)
PARALLELPERIOD_Sale = 
CALCULATE(
    SUM(SaleDate[Sales]),
    PARALLELPERIOD( SaleDate[Date], -1, MONTH )
)

 

 

I think we get different results because of different calculation contexts. Could you please share your sample data and models? That can help us find the cause faster. 

 

Best Regards,
Winniz