Skip to main content
cancel
Showing results for 
Search instead 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

Reply
squarecat
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.

squarecat_0-1702268843561.png

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

squarecat_1-1702269049256.png

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.

squarecat_2-1702269741542.png

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]))

squarecat_4-1702270273219.png

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
Bmejia
Solution Specialist
Solution Specialist

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

View solution in original post

2 REPLIES 2
Bmejia
Solution Specialist
Solution Specialist

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

This was it. Thank you so much.

Helpful resources

Announcements
Europe Fabric Conference

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

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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