Medida Dax o Columna Calculada para calcular el total acumulado por semestre

[mario1997]

Medida Dax o Columna Calculada para calcular el total acumulado por semestre, cual es la mejor opción y que recomendación me podrían dar para tener el total acumulado por semestre apartir de tabala calendario de fecha

[v-kongfanf-msft · Accepted solution]

Hi @mario1997 ,

You can try below formula to create measure or calculated column to get the cumulative total per semester. 

measure:

Cumulative Total = 
CALCULATE(
    SUM('YourTable'[Amount]),
    FILTER(
        ALL('YourTable'),
        'YourTable'[Semester] <= MAX('YourTable'[Semester])
    )
)

calculated column:

Cumulative Total_ = 
CALCULATE(
    SUM('YourTable'[Amount]),
    FILTER(
        ALL('YourTable'),
        'YourTable'[Semester] <= EARLIER('YourTable'[Semester])
    )
)

Best Regards,
Adamk Kong

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

[bhanu_gautam]

@mario1997 ,To calculate the accumulated total per semester in DAX, you can use a measure rather than a calculated column. Measures are generally more efficient for this type of calculation because they are evaluated in the context of the report and can dynamically respond to slicers and filters.

Like below

dax
AccumulatedTotalPerSemester =
CALCULATE(
SUM('YourTable'[YourValueColumn]),
FILTER(
ALL('DateTable'),
'DateTable'[Semester] <= MAX('DateTable'[Semester])
)
)