Forum Discussion

jjvelasco's avatar
jjvelasco
New Member
10 years ago

Accumulated Sales

Hello, Thank you in advance for time

I have a base where they have been stored sales since 2012 until today, now that we have our license powerbi, we want to make a comparative where we make the cumulative sales from January 1, 2016 until April 27, 2016, and compare it against the accumulated the same period last year.
I'm using this formula, but only sum selling me one day.

DATESBETWEEN('Date'[Date],STARTOFYEAR(Ventas[Fecha),LASTDATE(Venta[Fecha])))
could support me in what I have been doing wrong please?

Greetings

2 Replies

  • achinm45's avatar
    achinm45
    Advocate IV
    10 years ago

    Hi,

    Can you create two measures :

    1) Measure M1 =  TotalYtd(Sum(Sales),Date_Columns)

    2) Measure M2_Previous =  Calculate(SUM(Sales),SAMEPERIODLASTYEAR(Date_Column))

     

    And when you bring them both on table and slice by date , you may compare this year sales and last year sales.

     

    BR,

    Achin

    • Sean's avatar
      Sean
      Community Champion
      10 years ago

      Since you are doing YTD - change CALCULATE(SUM(Sales),... to CALCULATE([Measure M1], ... in the 2nd Measure

       

      if you have Year and Months in the rows of a Matrix

      the second measure will not show you Previous YearToDate but just Previous Year just for each Month

       

      Hope this makes sence - test it in a Matrix with Year and Month on the rows and you'll see what I mean.

       

      YTD is running total.