Aged Trial Balance Grouping Example In Power BI – Business Analytics With DAX


Today we’re covering a really unique accounting example. We are looking to create an aged trial balance grouping inside of Power BI.

The great thing about this technique is we can re-use many of the grouping and segmentation patterns that we have already learnt and try to apply them in other ways in our reports.

Utilizing these techniques for this unique example is no different and that’s the idea behind this tutorial to really show you how you can utilize some common segmentation patterns.

*****Video Details*****
0:16 – Introduction
1:20 – Aged Trial Balance Using Power BI
2:06 – Sample Data Set And Model Set Up
4:33 – Working Out The DAX Calculation
7:04 – Conclusion

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

***** Related Links *****
Use DAX To Segment & Group Data In Power BI

Use DAX To Segment & Group Data In Power BI


Segmentation Example Using Advanced DAX In Power BI

Segmentation Example Using Advanced DAX in Power BI


Power BI Advanced Analytics: Secondary Table Logic Techniques

Power BI Advanced Analytics: Secondary Table Logic Techniques

***** Related Course Modules *****
Business Analytics Series
http://portal.enterprisedna.co/p/business-analytics-series
Mastering DAX Calculations
http://portal.enterprisedna.co/p/mastering-dax-calculations
Advanced Analytics In Power BI
http://portal.enterprisedna.co/p/advanced-analytics

***** Related Support Forums *****
General Ledger Grouping
https://forum.enterprisedna.co/t/general-ledger-grouping/78
Group Customers by Income Groups
https://forum.enterprisedna.co/t/group-customers-by-income-groups/4620
DAX – Grouping Not Return Correct Total Value
https://forum.enterprisedna.co/t/dax-grouping-not-return-correct-total-value/789
For more grouping accounting queries to review see here…..
https://forum.enterprisedna.co/search?q=grouping%20accounting