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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DeepDive_A
Regular Visitor

Ledger Opening Balance/+ - Transactions / Closing Balance - at all parent levels...

Hi Experts !!

 

Need help on below :

I have opening balance (not at first date every time) and Transactions at Ledger level and also there is parent hierarchy of Ledgers.  I want to show next day opening balance as same of closing balance of last day (if opening balance is null) and closing balance is also calculated = opening + transaction of same day. And I also want to show all the same functionality of each parent ( example first parent opening = sum of first opening of all the childs, & first parent transactions = sum of total transaction of all the childs, and first parent closing=  sum of first opening of all the childs + sum of total transaction of all the childs)

 

Q2.png

 

 

 

 

 

Q1.png

 

 

 

Sample Data file link below :

https://1drv.ms/x/s!Ahf9AEri3UL4gQMvJWUKfsKgyIeK?e=LBnaEa

4 REPLIES 4
DeepDive
Helper IV
Helper IV

Hi experts.. is there any solution for this using Power BI

Hi @DeepDive && @DeepDive_A,

 

Been looking at your data but not really getting the information you present on your image vs the one on the excel file.

 

Whne you refer to the 20K of account 76 were does that value comes from? I cannot see that the accounts 76 has  any opening balance.

 

can you please elaborate on the calculations?


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Hi @MFelix  thanks for your reply. Actually I truncated the data... In the image am showing the dummy values...  The Excel data is like sample data of my model in which am using the date table as well... 

DeepDive_A
Regular Visitor

Hi Experts.. pls support on this .. thanks

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors