Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

Aggregate Running Total Monthly

Hi, I have the following measure on my line chart which shows a cumulative view by date. When my x-axis has day/month/quarter/year the lines increases cumulatively.    My legend is Prod[type]   ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Use the date from your calendar dimension table, not the prod fact table.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, M_SBS_6 

    To achieve a cumulative total by month, you can modify the measure to ensure that it matches the monthly context.
    You might want to try the DAX expression below:

    Run_total_Monthly = 
CALCULATE(
    SUM(prod[amt]),
    FILTER(
        ALLSELECTED(prod[date].[Month]),
        prod[date] <= MAX(prod[date])
    )
)

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, M_SBS_6 

To achieve a cumulative total by month, you can modify the measure to ensure that it matches the monthly context.
You might want to try the DAX expression below:

Run_total_Monthly = 
CALCULATE(
    SUM(prod[amt]),
    FILTER(
        ALLSELECTED(prod[date].[Month]),
        prod[date] <= MAX(prod[date])
    )
)

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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