Accounts Receivable Aging Schedule 05-30-2024 04:17 AM - last edited 01-18-2025 04:04 AM

[danextian]

⚡You've been probably been, at some point, asked to build an 𝐀𝐑 𝐀𝐠𝐢𝐧𝐠 𝐒𝐜𝐡𝐞𝐝𝐮𝐥𝐞 inside Power BI 📊✨, one that allows a user to see the amount due subdivided into different aging groups at a given date. 𝘈𝘙 𝘢𝘨𝘪𝘯𝘨 𝘪𝘴 𝘶𝘴𝘦𝘧𝘶𝘭 𝘪𝘯 𝘥𝘦𝘵𝘦𝘳𝘮𝘪𝘯𝘪𝘯𝘨 𝘵𝘩𝘦 𝘢𝘭𝘭𝘰𝘸𝘢𝘯𝘤𝘦 𝘧𝘰𝘳 𝘥𝘰𝘶𝘣𝘵𝘧𝘶𝘭 𝘢𝘤𝘤𝘰𝘶𝘯𝘵𝘴 𝘢𝘴 𝘸𝘦𝘭𝘭 𝘢𝘴 𝘪𝘯 𝘦𝘴𝘵𝘪𝘮𝘢𝘵𝘪𝘯𝘨 𝘵𝘩𝘦 𝘢𝘮𝘰𝘶𝘯𝘵 𝘵𝘰 𝘣𝘦 𝘸𝘳𝘪𝘵𝘵𝘦𝘯 𝘰𝘧𝘧. And you wondered if it could be done or if it was even possible. 💡

IT IS POSSIBLE!

In this sample report:

👉The age adjusts according to the slicer selection and is not static.

👉The visuals can be filtered down to a specific age range.

👉The balance can be drilled down to a specific invoice.

👉The colum headers that are visible change in response to the selected month (tab2).

Note:

●Data is randomly generated using Power Query so the numbers might not make sense.

●A slicer is used to change the fill color of the shapes and not bookmarks.

Tutorial -https://www.youtube.com/watch?v=FCqwP8I59kQ 
Sample PBIX  (over 200 MB) - https://onedrive.live.com/?authkey=%21AJdqEmgKHU3%2D2Xk&id=5F8ED775D41B4AAC%2120480&cid=5F8ED775D41B... 

eyJrIjoiMWQyN2ZiMjUtYmYzYy00YzViLThjNGMtMjU5NWRlOWNhMGZjIiwidCI6ImRmODY3OWNkLWE4MGUtNDVkOC05OWFjLWM4M2VkN2ZmOTVhMCJ9

[Mohamed_007]

Hi @danextian ,I appreciate if Could You Please Share the PBIX: 

[danextian]

Hi @Mohamed_007,

The link is on my YouTube channel - https://youtu.be/FCqwP8I59kQ

[OmarB85]

I really wish to see a tutorial on this. 

[shane149]

How many transactions is the AR table?  Just wondering how you were able to do it (aggregation, iteration, etc.) and if the report slows down if the AR of a company is massive amounts of data.