Help doing a line chart with a total agregated

[Syndicate_Admin]

Hello guys! I am using an Excel tabe called ZFACTURENRA that has lots of columns. I am trying to get an agregation of the total in "Volume" by "Billind date". To clarify this i want on the first day the total of that day, second day: total of day1 + total of day2, and so on, so the last day i will have the grand total of "Volume". I showed another column called "campaña agricola" to showed you i use to filter the info by this column wich is the year. I think i need a new column with this agregated total by day but i could not create the dax formula. I need this info to create a line chart with volume evolution week by week.

I will love any help you can bring me!!!

[Syndicate_Admin]

Liu you saved my life!!!!! Thank you so much!!!!!! 😁

[Anonymous · Accepted solution]

Hi  @Syndicate_Admin ,

Here are the steps you can follow：

1. Create measure.

Measure =
SUMX(
    FILTER(ALL('Table'),
    'Table'[Billing Date]<=MAX('Table'[Billing Date])),[Volumen])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly