Forum Discussion
Total Sales Last Year , Need Help!!
Hi!
Need help with the following scenario:
I need to calculate the count of Last Year YTD Sales:
LY YTD Sales = TOTALYTD([YTD Sales],SAMEPERIODLASTYEAR('BASE BBI AS400'[Fecha Activación].[Date]))
Apparently it is showing the amount of all sales in 2016 and not the value YTD I am looking for, it shows all 2016 sales.
I used the following formula to calculate YTD sales:
YTD Sales = TOTALYTD(COUNTAX('BASE BBI AS400','BASE BBI AS400'[Anexo]),'BASE BBI AS400'[Fecha Activación].[Date])
This formula shows the exact amount for sales starting 01/Jan/2017.
How can I fix the formula to show the total last year from same period on this year?
Have a bit of a read through this article.
https://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/
and see if that helps any,
1 Reply
- Phil_SeamarkMicrosoft Employee
Have a bit of a read through this article.
https://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/
and see if that helps any,