Accumulated Sales

[jjvelasco]

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

[achinm45]

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]

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.