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

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

Can you do something like this in a measure

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

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.

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 - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors