Conditional Sum/Acumulado por mes condicional

[ZunzunUOC]

Hi everybody, I need help with a query / Saludos a tod@s. Necesito ayuda con una consulta.

I have the next data: / Parto de los siguientes datos (simplificado):

I need to sum every month the ID's values with end date is fewer than agreement date/ Lo que necesito es cálcular cada mes cuánto importe se ha adelantado por ID adelantado (fecha cierre<fecha compromiso) y que además lo calcule cada mes, es decir, si ponemos de ejemplo el ID '8' tendría que contar en el mes de abril, mayo y junio.

The result must be (Omitting third colunm): / De esta forma, el resultado debería ser algo como esto:

Thanks / Gracias!

[ZunzunUOC · Accepted solution]

Finally, I have created a new table and the next calculated column works:

Result = CALCULATE(SUM('Report Diario'[Amount]);FILTER('Report Diario';AND(Calendario[Date]<'Report Diario'[Agreement Date];AND(Calendario[Date]>'Report Diario'[End Date];NOT(ISBLANK('Report Diario'[End Date]))))))

[ZunzunUOC]

Hi again, I'm working on that.

MedidaAcumulado = CALCULATE(SUM('Report Diario'[Amount]);FILTER('Report Diario';'Report Diario'[End Date]<'Report Diario'[Agreement Date]))

That works, but just sum the amount in the month wich is equal at End Date.

[v-chuncz-msft]

@ZunzunUOC ,

You may check if the following post helps.

https://community.powerbi.com/t5/Developer/Dax-Help-Create-table-with-variable-of-lines-according-to...

[ZunzunUOC]

Hi @v-chuncz-msft, thank so much for your reply.

Maybe, I didn't explain correctly.

If I have an ID with the next information:

Start Date: 01/01/19

Agreement date: 08/15/19

End Date: 30/04/2019

Amount: 100€

I need to sum the amount on May, June and July; due to the end date is fewer than agreement date.

Thanks for your help.

[ZunzunUOC]

I have updated with the english language. Thanks.