Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Vinothsusai
Helper III
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.

 

Could you please advise.

 

IdDescriptionMainAccountDateAmount
40PARENTS REVENUE R7060001/1/20212000
41RETURN CHECK/DD FEES INVOICED R70615022/2/20212800
42CREDIT NOTES - PARENTS R70690010/3/20212800
44DISCOUNTS R7069104/4/20212091
46DISCOUNTS ON SPECIAL OFFERS R7069208/5/20212800
48PARENTS REVENUE SUBSIDIES R74100013/6/2021200
50CATERING FEES R7060502/7/20212005
52MEDICAL FEES R70635019/8/2021235
54TRANSPORTATION REVENUE R7061008/5/20212010
58OTHER CHILDCARE REVENUE R70620010/3/2021220
59Credit Note - Parents Catering R70690311/10/202190
60ENRICHMENT INCOME R70805010/12/20215
61UNIFORMS/ATTIRE INCOME R70860010/3/2021260
62REGISTRATION FEES R70800211/10/20210
REV1Parents Revenue Total40+41+42+44+46+48+50+52+54+58+59+60+61+62  
68% Total Parents RevenueREV1/REV7  
72OPERATING SUBSIDIES R7400003/1/20212000
73Operating Subsidies - BaWü R7401004/4/20212800
74MFF SUBSIDIES R7402008/5/20212020
76BUMI SUBSIDIES R74025013/6/2021225
78FOOD PROGRAM REVENUE R7403002/7/20212030
80TRANSPORTATION REVENUES R74035019/8/2021235
81PARENTS REVENUE SUBSIDIES - Catering R7410508/5/20212005
82PARENTS REVENUE SUBSIDIES - MFF R74120010/3/2021220
83OTHER OPERATING SUBSIDIES R74200011/10/20210
84OPERATING SUBSIDIES ADJUSTMENTS R74200110/12/20210
86CONTROL CAF R74200410/3/2021200
87Other subsidies R74200511/10/20210
REV2Subsidies Total72+73+74+76+78+80+81+82+83+84+86+87  
89% Total Subsidies RevenueREV2/REV7  
REV3Total Childcare RevenueREV1+REV2  
91% Total Childcare RevenueREV3/REV7  
93SPONSOR FEES - CORPORATES R7060018/5/20212800
94CREDIT NOTES – CORPORATES R70690113/6/20212800
95Key Accounts R7080052/7/20212000
96State & Hospital R70800619/8/2021200
97Small business & Regional Group R7080078/5/20212000
99VACANT CRADLES INVOICED R70810010/3/2021210
REV4Total Corporate Revenue93+94+95+96+97+99+REV4  
100% Total Corporate RevenueREV4/REV7  
102SPONSOR FEES - MUNICIPALITIES R7060022/7/20212800
104CREDIT NOTES - MUNICIPALITIES R70690219/8/20213100
106MUNICIPALITIES BONUS AND PENALTIES R7061028/5/20212800
REV5Total Municipalities Revenue102+104+106  
110% Total Municipalities RevenueREV5/REV7  
116IC PERSONNEL REINVOICING R7084242/7/20212042
120OTHER REVENUE R70800119/8/2021200
REV6Total Other Revenue116+120  
140% Total Other RevenueREV6/REV7  
REV7Total Nurseries RevenueREV3+REV4+REV5+REV6  

 

 

 

Thanks

Vinoth

 

 

2 REPLIES 2
Vinothsusai
Helper III
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

Vinothsusai
Helper III
Helper III

Hello,

Any advise please on the percentage calculation in DAX.

 

Thanks

Vinoth

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.