Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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)
Sample Data file link below :
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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...
Hi Experts.. pls support on this .. thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
124 | |
77 | |
74 | |
58 | |
49 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |