cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## 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 2

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

Community Champion

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors