Forum Discussion

DarylM's avatar
DarylM
Icon for Helper II rankHelper II
9 years ago
Solved

Sales total to current date from previous year

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 ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    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's avatar
DarylM
Icon for Helper II rankHelper II
9 years ago

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's avatar
kroeterix
Frequent Visitor
9 years ago

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