Forum Discussion

espinozan's avatar
espinozan
Helper I
9 years ago
Solved

YTD Revenue Calculation

Hi everyone,   I'm trying to create a measure in my report that calculates YTD Revenue but somehow I can't get it to do what I'm looking for. I have data ranging from Jan 2016 to Apr 2017. My measu...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    Hi espinozan,

     

    It seems that it's something wrong with the report. The "year" context should always be there with function "TOTALYTD". Have a look at the example in the picture. The "TotalYTD" will accumulate in one year (2007). And it will start from 0 in the next year.

     

    You have data of two years. So the result will be wrong if there is only a month context. Please try to create a report as the picture showed. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

espinozan's avatar
espinozan
Helper I
9 years ago

Thanks v-jiascu-msft,

 

This helps alot, thank you. But is there to do a continuing YTD? Meaning it gives me a running sum for 12 months prior to today's date.

 

 

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

Hi espinozan,

 

Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.

Best Regards!
Dale