Forum Discussion
YTD last year
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,
Hi Anonymous
If you believe this answers your question, Please mark it as accepted solution so it can be helpful to others as well
Super User
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))
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.
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
If you believe this answers your question, Please mark it as accepted solution so it can be helpful to others as well