Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
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
What I did create a MEASURE (Acumulado_Proveedor_Monto_Asignado) where I made an accumulated sum per day of the USD Quota
To then make the division between the 2 measures
I do not know if I am doing well but if you need more data to help me I would appreciate it
Best regards
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |