Help doing a line chart with a total agregated

[Anonymous]

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!!!

[Anonymous]

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

[Syndicate_Admin · Accepted solution]

@Syndicate_Admin ,

Estos son los pasos que puede seguir:

1. Crear medida.

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

2. Resultado:

Saludos

Liu Yang

Si esta publicación ayuda, considere Aceptarlo como la solución para ayudar a los otros miembros a encontrarlo más rápidamente.