Cumulative Percentage by Days, Month, Year and other variables

[Syndicate_Admin]

Dear

 

I need your support, I want to create a graph of increasing lines in percentage, that is, add the amount recovered (AMOUNT PAID) and divide it with the total that is assigned (USD QUOTA) but this cumulatively (daily), the idea is to be able to buy by months or suppliers or different criteria and that the lines move according to the filters used.

For example

The -10th day of the month of Set21 my accumulated recovery is 1%

The -10 day of the month of Oct21mi accumulated recovery is 1.5%

The day -10 of the month of Nov21mi accumulated recovery is 1.5%

.

.

.

On the 20th of the month of Set21 my accumulated recovery is 84%

The 20th day of the month of Oct21mi accumulated recovery is 85%

On the 20th of the month of Nov21mi accumulated recovery is 86%

.

.

etc.

The data I have in my table are:

In advance thank you for your comments

Some doubt they send me

Best regards

miguel o.

[v-eqin-msft]

Hi @Syndicate_Admin ,

Sorry for that the information you have provided is not making the problem clear to me.

What's the logic of the accumulated recovery?  Could you please provide me with more details about your table in Text/Table format?( not in a screenshot) Or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[Syndicate_Admin]

Hello

The logic of the recovery is Amount Paid / (between) USD Fee, this will give me as a result the percentage of recovery, but what I want is to do it cumulatively.

I was working on the solution but in some days the percentage falls when I make my accumulated sum

What I did create a MEASURE (Acumulado_Proveedor_Monto_Pago) where I made an accumulated sum per day of the Amount Paid

Acumulado_Proveedor_Monto_Pago = (CALCULATE(SUM(KPI_PREJUDICIAL[Payment Amount]),

FILTER(ALLEXCEPT(

KPI_PREJUDICIAL,

KPI_PREJUDICIAL[Cycle],

KPI_PREJUDICIAL[Mes_Ano],

KPI_PREJUDICIAL[SECTION],

KPI_PREJUDICIAL[SUB_TRAMO],

KPI_PREJUDICIAL[Provider]

),

KPI_PREJUDICIAL[DIA_GESTION]<= MAX(KPI_PREJUDICIAL[DIA_GESTION]))))

What I did create a MEASURE (Acumulado_Proveedor_Monto_Asignado) where I made an accumulated sum per day of the USD Quota

Acumulado_Proveedor_Monto_Asignado = (CALCULATE(SUM(KPI_PREJUDICIAL[USD Fee]),

FILTER(ALLEXCEPT(

KPI_PREJUDICIAL,

KPI_PREJUDICIAL[MES_TEXTO],

KPI_PREJUDICIAL[Mes_Ano],

KPI_PREJUDICIAL[Provider],

KPI_PREJUDICIAL[Cycle],

KPI_PREJUDICIAL[SECTION],

KPI_PREJUDICIAL[SUB_TRAMO]

),

KPI_PREJUDICIAL[USD Fee])))

To then make the division between the 2 measures

Recovery % Supplier = KPI_PREJUDICIAL[Acumulado_Proveedor_Monto_Pago]/KPI_PREJUDICIAL[Acumulado_Proveedor_Monto_Asignado]

I do not know if I am doing well but if you need more data to help me I would appreciate it

Best regards