Forum Discussion

jsteffe's avatar
jsteffe
Icon for Helper III rankHelper III
6 years ago
Solved

Difference between measure and calculated column

Hello, If I write this formula in a measure, I get the good result as it calculates the amount of sales for the next year. CALCULATE(SUM(Sales[amount]);NEXTYEAR('Calendar'[Date]))   But if I put...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi jsteffe ,

     

    It is because of the row context,you need to correct your expression as below:

     

    CALCULATE(SUM(Sales[amount]),'Sales',NEXTYEAR('Calendar'[Date]))

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi jsteffe ,

 

It is because of the row context,you need to correct your expression as below:

 

CALCULATE(SUM(Sales[amount]),'Sales',NEXTYEAR('Calendar'[Date]))

 

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!