cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

## Comparation of cummulative sales by month

Hello everyone,

I have been struggling with the creation of a line chart that shows the cummulative sales by month of my company. When I thought i finally found the way to display it I realized that the sales for each month are way off when displayed in the chart. Here is a screenshot of March where it shows that the numbers are almost in the billions.

When in reality the numbers should be around 30-40 million in March

As the start of the year is Oct 1 in my company, I made this Calendar table to help me with the order of the months in the chart so it doesn't go from Jan-Dec and goes Oct-Sep instead.

Then, as there are multiple sales in a single day i decided to create tables that summarize the quantity of sales for each day and then do the cummulative using this expression:

``Venta acumulada = CALCULATE(SUM('21-22'[Venta total]),ALL('21-22'),'21-22'[Fecha] <= EARLIER('21-22'[Fecha]))``

The tables are fine and they show the correct amount of sales, but when I try to use this data in the chart it goes crazy.

What can I do?

1 ACCEPTED SOLUTION
Solution Supplier

Can you do something like this in a measure

Cumulative FY =
CALCULATE(
SUMX(YourTable,YourTable[Venta Total]), -- Sum Your Total
2 REPLIES 2
Solution Supplier

Can you do something like this in a measure

Cumulative FY =
CALCULATE(
SUMX(YourTable,YourTable[Venta Total]), -- Sum Your Total
New Member

This was it. Thank you so much.