Forum Discussion

Onaiggac's avatar
Onaiggac
Advocate II
9 years ago
Solved

SAMEPERIODLASTYEAR goes wrong for quarter

I have two main calculated columns. The first one is for calculate using the SAMEPERIODLASTYEAR function.   AnoPre = CALCULATE(SUM(vw_VariacaoTotalResiduosXCategoria[Peso(t)]); SAMEPERIODLASTYEAR(...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Onaiggac,

     

    According to your description above, I think the measure AnoPre is correct, and it should work. The problem should be related to your Quarter column.

     

    From the screenshots you posted above, you have a month called "Jan/17" for 2017 Jan, but the quarter "First" for 2017 Q1? Shouldn't it be "First/2017"? So you may need to change the values for Quarter correctly to make it work. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Onaiggac,

 

According to your description above, I think the measure AnoPre is correct, and it should work. The problem should be related to your Quarter column.

 

From the screenshots you posted above, you have a month called "Jan/17" for 2017 Jan, but the quarter "First" for 2017 Q1? Shouldn't it be "First/2017"? So you may need to change the values for Quarter correctly to make it work. :smileyhappy:

 

Regards