Comparation of cummulative sales by month

[squarecat]

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?

[Bmejia · Accepted solution]

Can you do something like this in a measure

Cumulative FY =

CALCULATE(

    SUMX(YourTable,YourTable[Venta Total]), -- Sum Your Total

    DATESYTD('Date'[Date],"9/30"))   -- Your Date/Fecha Table

[squarecat]

This was it. Thank you so much.