Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Previous year December value

Hi I want to show the value of December previous year. I followed the steps that is posted but couldn't get the result. here is the measure: MeasureValue1 = CALCULATE(SUM('Table'[value1]),FILTER(...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    IF 

    you can try this

     

    Measure = 
VAR yr=right(SELECTEDVALUE('Table'[Month.Year]),4)-1
return SUMX(FILTER(all('Table'),'Table'[Month.Year]="12."&yr),'Table'[value1])

     

    please kindly check the below pbix file.

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
5 years ago

IF 

you can try this

 

Measure = 
VAR yr=right(SELECTEDVALUE('Table'[Month.Year]),4)-1
return SUMX(FILTER(all('Table'),'Table'[Month.Year]="12."&yr),'Table'[value1])

 

please kindly check the below pbix file.