Launch-to-date sales of products

[Anonymous]

Hi all,

I have made some YTD calculation that works fine, but now im looking to make a  LTD (launch-to-date) calculation.

So with the YTD i can measure from 01-01-2018 until now, but i want to specify that i will measure from 01-04-2018 until now, it has to be accumulated numbers.

any advice? 

[Anonymous]

its not working as expected after all, but i cant remove the "accept as solution" mark

[rajulshah]

Hello @Anonymous,

I also don't know that. But can you provide what's expected ?

[rajulshah · Accepted solution]

Hello @Anonymous,

Please try the following measure:

YTS Rev. = TOTALYTD(SUM('Sales RAW'[Rev. Actual excl.WAS]);'CALENDAR'[Date].[Date],"31/3")

Hope this works.