Forum Discussion

Stroopwafels's avatar
Stroopwafels
Regular Visitor
8 years ago

How to correctly adjust your YTD formula?

Hello everyone, 

 

I need your help with my YTD formula: 

 

YTD = CALCULATE(TOTALREVENUES[salesdata]; DATESBETWEEN(salesdata[date_processed]
; DATE( year(MAX(salesdata[date_processed])); 1;1)
; DATE( year(MAX(salesdata[date_processed])); month(lastdate(all(salesdata[date_processed]))); day(LASTDATE(all(salesdata[date_processed]))))))

 

The below formula was working for me last year but since this year, the formula is comparing 5th january 2018 with 4th of january 2017 while 5-1-2018 is on a friday and 4-1-2017 is on a wednesday. 

 

Can anyone please help me? 

 

Cheers, 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Stroopwafels

     

    In your scenario, as you said that your YTD formula is comparing 2018-1-5 with 2017-1-4. Then what’s wrong with it? What’s your expected result?

     

    I’m not quite understand about your requirement. Please elaborate your issue by sharing us more information like some sample data and your desired output. Otherwise, we can only make a guess.

     

    By the way, to calculate the YTD value. I don’t think you need to specify such complicate formula. Please refer to TOTALYTD Function.

     

    Thanks,
    Xi Jin.