Power BI: How to Create Aging Reports 👵 by Bins/Buckets (Showing Open/Overdue Items)

[@pabeader1941]

New Group??? BOOOOOOM!!! That's the sound of my mind...

[@joeparks812]

This tutorial was the answer to my prayers. Thank you Avi! Power On!

[@PowerBIPro]

Glad it helped!

[@jyotisingh6517]

Some hazy block is covering the screen not able to see, can you remove that from the video, so can see properly

[@Picla_Peremohy]

Yes, I kept thinking it was a problem on my end. It finally disappears around 13:55. Was still able to grasp the lesson.

[@mx2727]

Thank you for your time!! It helps me a lot!!

[@kennethstephani692]

Great video!

[@PowerBIPro]

Glad you enjoyed it

[@ligang2683]

Hi Avi Many thanks for this practical power BI video. If I follow along using the Power Query Editor approach, I will be prompted with a DataSource Error as I do not have access to Aging_Report_Work_Order_Dummy_Data.xlsx. As an alternative, would it be feasible to use the DAX approach to create the Age column?

[@lijunchen]

Great tutorial, very clear explanation. Is it possible to use the customized order age groups as a legend in the open order trend chart? So we know how the # of open orders in each age group across time? It seems the age group measure cannot be used in a legend. Any advice is appreciated.

[@tazinurrahman893]

I couldn´t find the relevant file in the download link provided, it happened with another video where I looked for the practice file

[@PowerBIPro]

Hey Muhammad, really sorry about that. We are investigating and would respond soon. Meanwhile you can also send us an email at [e-mail]

[@bfmarcha]

This is a great video, but I couldn't find the Ageing files at the download link. I got YTD Sales files instead.

[@PlumpRope]

Hi Avi, great to see you do that with the bins, very clean. I'm really curious for the last part though, where the historical trend is included. Is there going to be a video on this as well?

[@PowerBIPro]

Hey Neils, Glad you liked the video. Generally we aim for A) KZbin Channel = Content for Beginners B) LearnPowerBI Training Program www.learnpowerbi.com/training Also aimed for beginners, but step-by-step structured content so they can learn Power BI end to end. C) Advanced Program: Under Construction www.learnpowerbi.com/advanced Our Advanced Program is where we would include the detailed video with trends. That's the plan for now :-) Power On! / Avi

[@praveeng7066]

Could you pls create a inventory aging Report for given period of time with slots(0-90,91-120,121-181...)

[@shivamarora1696]

You found solution for this? I'm stuck

[@MehulPopat1]

Hey Avi, By any chance can you share excel sheet for practice. Thanks

[@hermitally419]

Hey Avi, how do we set up our data to look similar to a heat map style tree map? Like the ones you see for the SP500?

[@PowerBIPro]

Hey Hermit, can you send us a link to what one of these looks like?

[@JiffyDealer]

Hello, I need to create an aging report that shows the PROJECTED age group of items per date unit. keep in mind, new items are expected in every month and old items are expected out on a certain date. How do I calculate so that I can show by month, by age group, the expected number of items? Its to answer "We have x amount in our fleet today and they fall in these yearly brackets,this is the forecasted age bracket of our fleet by month

[@PowerBIPro]

Hey Daniel, thanks for being a subscriber 💛. That's an interesting scenario. Let me see if I get this right... Your data perhaps looks like this Vessel_ID Start_Date End_Date 001 Jan 1, 2022 Jul 1, 2022 002 Feb 1, 2022 Feb 1, 2023 003 Apr 1, 2022 Dec 1, 2022 004 Sep 1, 2022 Aug 1, 2023 So it has the Start Date and End Date. But in some cases the Start Date is actually expected Start Date (e.g. Vessel 004 starts in future). And in some cases the End Date is in future and is the expected end date. Now the data does not have to be exactly in this format...but I am getting it right at high level? If I am, then I can totally see, how and why you would be interested in showing that on a given future month, what would be the average age of the fleet? Which ones would be the oldest vessel etc. If so, what you would be looking for would be the "Trend" graphs I allude to at the end of this video. If you can do the trend going back in past, you can also do it going forward in future. I do plan to create the videos showing the "Trend" but the plan is to include them in our Advanced Power BI Course. Generally we aim for A) KZbin Channel = Content for Beginners B) LearnPowerBI Training Program www.learnpowerbi.com/training Also aimed for beginners, but step-by-step structured content so they can learn Power BI end to end. C) Advanced Program: Under Construction www.learnpowerbi.com/advanced Our Advanced Program is where we would include the detailed video with trends. Power On! / Avi

[@JiffyDealer]

@@PowerBIPro Your response is spot on and thank you so much for replying. Basically, older vessels pose more of a risk of breaking down than newer ones, so I’d like a table/bar chart that shows the projected age group out 24 months. With the expected out to facilitate conversations like “our current plan to replace vessels is requiring x% to run y years long. I’ll put together a mock up of the desired outcome and reply with a link in the next 1-2 days.

[@JiffyDealer]

@@PowerBIPro Hello, thank you again for replying. here is a link to a mock up in excel i.imgur.com/Ngrba1w.png basically, we're going to needing to run vessels past their warranty date, so we want to see how much of the fleet is exposed per month

[@inamullahkhan5761]

tell me more than 2 measure slicer

[@mazharhussain8871]

You are not comfortable with this yourself.