Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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 Supplier
Solution Supplier

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 Supplier
Solution Supplier

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.