Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Medida acumulada suma medidas

hola, necesito crear una medida que me permita sumar el acumulado de la medida ejemplo en febrero me sume (2,23 +-3,02).. etc. Y si lo muestro en una tarjeta me muestre la suma total. porque lo que a...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

    If you want to achieve accumulation in a year, you can consider creating a date table, and then associate the date table with the data table, and use DATESYTD() functions, you can refer to the following example

    Sample data

    Date table

    The relationship 

    Sample measure

    Test = MAX('Table'[Value])

    Now we're going to implement the accumulation of test measure.

    Create a new measure.

    Measure = CALCULATE(SUMX('Table',[Test]),DATESYTD('Date'[Date]))

    Output

     

    And you can refer to the following link about the function.

    DATESYTD function (DAX) - DAX | Microsoft Learn

     

    Best Regards!

    Yolo Zhu

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