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?
Go to Solution.
Have a bit of a read through this article.
and see if that helps any,
Proud to be a Datanaut!
View solution in original post
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!