Sales total to current date from previous year

[DarylM]

Hi, 

I am struggling to find a way to compare a true total of sales for last year to current date this year. 

I am using the "sameperiodlastyear" function, but it returns the entire total for last year. 

PYTD Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Unlabeled Jarred Goods Sales'[Date].[Date]))

I need to show the total of sales up to the last date of the current years sales. 

Any thoughts?

[v-yulgu-msft · Accepted solution]

Hi @DarylM,

Please try this formula:

PYTD Sales =
    CALCULATE (
        [Total Sales],
        PARALLELPERIOD (
            LASTNONBLANK ( 'Unlabeled Jarred Goods Sales'[Date], 1 ),
            -1,
            YEAR
        )
    )

If you have any question, please feel free to ask.

Thanks,
Yuliana Gu

[DarylM]

To elaborate, I am date product sales 1/1/15 through 10/25/16. I need to show the sales for 2015 up to 10/25. These dates will continue to populate as we go through the year. I am having trouble finding a way to calculate this with DAX. 

[kroeterix]

Hi,

as long as you only compare years I have a solution here.  In this thread I am looking for a solution that also works with months, quarters etc as well.

Sammy