Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

Help doing a line chart with a total agregated

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's avatar
    Anonymous
    3 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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