YTD last year

[Anonymous]

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('QUERY MONTHLY RESULTS PBI'[Net turnover (OC)]); DATESYTD('Calendar'[Date]))

Net TO YTD Y-1 = CALCULATE([Net TO YTD];SAMEPERIODLASTYEAR('Calendar'[Date]))

How can i fix this? Can someone help me with this?

Thanks!

Best regards,

[Anonymous · Accepted solution]

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]

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]

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,

[BhaveshPatel]

Hi @Anonymous 

If you slice it by MonthYear column from your calendar table, It will show the YTD and PreYTD Results.

If you are looking to get the YTD and PreYTD upto current period,

You can follow through the most recent article published on sqlbi:

https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/

There are quite a few different ways as well to get this outcome.

[Anonymous · Accepted solution]

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 · Accepted solution]

Hi @Anonymous 

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

[Anonymous]

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,