Forum Discussion
Calculate Percentage on values
Hi, I need a help on calculating % Percentual values from some data filtered into Ballons Options from an excel file (as database) Is there anyway to include bellot % of the grand total...
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Screenshots are not helpful.
Hi,
This is how values are grouped
ConceptoFecha de documentoVencimiento netoDemora tras vencimiento netoCategoria de VencimientoImporte en moneda doc.Moneda del documento
Concept | Document Date | Due Date | Due Days | Ageing | Amount | USD |
Demora | 1/10/2019 | 1/10/2019 | 1.102 | (6) +181 DAYS | 90,00 | USD |
| Demora | 13/11/2019 | 13/11/2019 | 1.059 | (6) +181 DAYS | 45,00 | USD |
| Flete / Manifestado | 28/11/2019 | 28/11/2019 | 1.044 | (6) +181 DAYS | 300,00 | USD |
| Flete / Manifestado | 28/11/2019 | 28/11/2019 | 1.044 | (6) +181 DAYS | 300,00 | USD |
| Flete / Manifestado | 18/12/2019 | 18/12/2019 | 1.024 | (6) +181 DAYS | 300,00 | USD |
| Flete / Manifestado | 18/12/2019 | 18/12/2019 | 1.024 | (6) +181 DAYS | 300,00 | USD |
Highlighted are the groups that i show on Report.
Hope this helps.
Thanks