cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper III

## Percentage calculation is not spliting by Month in Matrix table

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.

 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

2 REPLIES 2
Helper III

Hello,

I have achieved this specific formula on total and percentage row by using Financial reporting matrix tool below.

https://www.profitbase.com/powerbi/

I am facing the problem rendering data is little slow and also i cannot do "show data as point table" on each row.

Expert,

Please advise on this, it can achieve through native power bi matrix table using DAX expressions?

Thanks

Vinoth

Helper III

Hello,

Thanks

Vinoth