Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

YTD last year

Hi everybody,   I calculate a YTD and i try to compute The total YTD for the last year but it's give me a wrong value, it show me the total of the previous year:   Net TO YTD = TOTALYTD(SUM('QUE...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi BhaveshPatel,

     

    I slice by month an by Year and also change my Expression to calculate "Total Net TO of Last Year" by putting a new filter in my CALCULATE Function to keep the expression doing the right calcul, because by slicing the value change.

     

    Best regards,

  • BhaveshPatel's avatar
    BhaveshPatel
    7 years ago

    Hi Anonymous 

     

    If you believe this answers your question, Please mark it as accepted solution so it can be helpful to others as well

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
7 years ago

 

Hi Anonymous 

 

You can use something like this:

 

 

[Prev Yr YTD] =

CALCULATE(SUM('QUERY MONTHLY RESULTS PBI'[Net turnover (OC)]), DATEADD(DATESYTD(Calendar[Date]),-1,Year))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi BhaveshPatel ,

 

Thanks for your reply!

I try what you suggest me but it's give me the same value as before.

The value is equal to Tatal of previous Year.

 

Best regards,