Forum Discussion

hadjigeo's avatar
hadjigeo
Icon for Helper I rankHelper I
6 years ago

DATEADD - last Quarter issue when select March

Hi,

 

i am using DATEADD to find the results from the previous quarter

 

Last Quarter Performance = CALCULATE(DIVIDE(SUM('PM Main JO'[C GRAND TOTAL PM]),[Bonus Allocation]),DATEADD('Date'[Date],-3,MONTH))
 
when i select March, for some reason it gives me some numbers which i dont know how it was calculated, as i have upload only 1 year. 
 
what can i do in order to show 0 for the previous quarter when i select March?
 
Thanks,
Haris
Need Help

5 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    6 years ago

    hadjigeo 

    Does your Date table cover full years (Jan 1 - Dec 31)?  I have seen odd behavior from time intelligent functions if you only have part of a year in the dates table.

      • jdbuchanan71's avatar
        jdbuchanan71
        Icon for Super User rankSuper User
        6 years ago

        That could be the problem, change it to cover full years and see if that helps.