Forum Discussion
Medida acumulada suma medidas
- Anonymous2 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.
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.
Muchas gracias, funciona perfecto.
Pero me surgió otra duda, si yo quiero hacer acumulado con datos del año 2024 tambien es decir quiero sumar de enero 2023 a enero 2024 o más, como lo deberia hacer? porque al hacerlo actualmente me devuelve 0%