Hi,
I am constructing a PL report based on the static template of Finance operations(Ledger transactions). Here i listed only few records to explain my problem.
Based on the Ids listed, i am trying to calculating total and percentage in DAX formula.
The amount and percentage should be calculated by the month split in matrix table Jan,feb.....dec.
Could you please advise.
| Id | Description | MainAccount | Date | Amount |
| 40 | PARENTS REVENUE | R706000 | 1/1/2021 | 2000 |
| 41 | RETURN CHECK/DD FEES INVOICED | R706150 | 22/2/2021 | 2800 |
| 42 | CREDIT NOTES - PARENTS | R706900 | 10/3/2021 | 2800 |
| 44 | DISCOUNTS | R706910 | 4/4/2021 | 2091 |
| 46 | DISCOUNTS ON SPECIAL OFFERS | R706920 | 8/5/2021 | 2800 |
| 48 | PARENTS REVENUE SUBSIDIES | R741000 | 13/6/2021 | 200 |
| 50 | CATERING FEES | R706050 | 2/7/2021 | 2005 |
| 52 | MEDICAL FEES | R706350 | 19/8/2021 | 235 |
| 54 | TRANSPORTATION REVENUE | R706100 | 8/5/2021 | 2010 |
| 58 | OTHER CHILDCARE REVENUE | R706200 | 10/3/2021 | 220 |
| 59 | Credit Note - Parents Catering | R706903 | 11/10/2021 | 90 |
| 60 | ENRICHMENT INCOME | R708050 | 10/12/2021 | 5 |
| 61 | UNIFORMS/ATTIRE INCOME | R708600 | 10/3/2021 | 260 |
| 62 | REGISTRATION FEES | R708002 | 11/10/2021 | 0 |
| REV1 | Parents Revenue Total | 40+41+42+44+46+48+50+52+54+58+59+60+61+62 | | |
| 68 | % Total Parents Revenue | REV1/REV7 | | |
| 72 | OPERATING SUBSIDIES | R740000 | 3/1/2021 | 2000 |
| 73 | Operating Subsidies - BaWü | R740100 | 4/4/2021 | 2800 |
| 74 | MFF SUBSIDIES | R740200 | 8/5/2021 | 2020 |
| 76 | BUMI SUBSIDIES | R740250 | 13/6/2021 | 225 |
| 78 | FOOD PROGRAM REVENUE | R740300 | 2/7/2021 | 2030 |
| 80 | TRANSPORTATION REVENUES | R740350 | 19/8/2021 | 235 |
| 81 | PARENTS REVENUE SUBSIDIES - Catering | R741050 | 8/5/2021 | 2005 |
| 82 | PARENTS REVENUE SUBSIDIES - MFF | R741200 | 10/3/2021 | 220 |
| 83 | OTHER OPERATING SUBSIDIES | R742000 | 11/10/2021 | 0 |
| 84 | OPERATING SUBSIDIES ADJUSTMENTS | R742001 | 10/12/2021 | 0 |
| 86 | CONTROL CAF | R742004 | 10/3/2021 | 200 |
| 87 | Other subsidies | R742005 | 11/10/2021 | 0 |
| REV2 | Subsidies Total | 72+73+74+76+78+80+81+82+83+84+86+87 | | |
| 89 | % Total Subsidies Revenue | REV2/REV7 | | |
| REV3 | Total Childcare Revenue | REV1+REV2 | | |
| 91 | % Total Childcare Revenue | REV3/REV7 | | |
| 93 | SPONSOR FEES - CORPORATES | R706001 | 8/5/2021 | 2800 |
| 94 | CREDIT NOTES – CORPORATES | R706901 | 13/6/2021 | 2800 |
| 95 | Key Accounts | R708005 | 2/7/2021 | 2000 |
| 96 | State & Hospital | R708006 | 19/8/2021 | 200 |
| 97 | Small business & Regional Group | R708007 | 8/5/2021 | 2000 |
| 99 | VACANT CRADLES INVOICED | R708100 | 10/3/2021 | 210 |
| REV4 | Total Corporate Revenue | 93+94+95+96+97+99+REV4 | | |
| 100 | % Total Corporate Revenue | REV4/REV7 | | |
| 102 | SPONSOR FEES - MUNICIPALITIES | R706002 | 2/7/2021 | 2800 |
| 104 | CREDIT NOTES - MUNICIPALITIES | R706902 | 19/8/2021 | 3100 |
| 106 | MUNICIPALITIES BONUS AND PENALTIES | R706102 | 8/5/2021 | 2800 |
| REV5 | Total Municipalities Revenue | 102+104+106 | | |
| 110 | % Total Municipalities Revenue | REV5/REV7 | | |
| 116 | IC PERSONNEL REINVOICING | R708424 | 2/7/2021 | 2042 |
| 120 | OTHER REVENUE | R708001 | 19/8/2021 | 200 |
| REV6 | Total Other Revenue | 116+120 | | |
| 140 | % Total Other Revenue | REV6/REV7 | | |
| REV7 | Total Nurseries Revenue | REV3+REV4+REV5+REV6 | | |
Thanks
Vinoth
