In this Power BI Q&A episode, we address a question from Paolo Damiani (LearnPowerBI member): How to create Bette Aging reports.
Download the Power BI file used in the video: https://web.learnpowerbi.com/download
Connect with Paolo Damiani on LinkedIn: https://www.linkedin.com/in/paolodamiani/
Do you have a question about Power BI
Stuck trying to get a DAX measurement to work
Unable to execute query editor steps correctly
The visuals just don't behave! Argh!
Find out how to get answers to your questions at https://www.learnpowerbi.com/question
️ Video chapters
00:00 Question: How to create a better aging report?
02:55 Step 1: Examine the model
03:48 Step 2: Examine the data (human learning)
05:42 Step 3A: Solve using the Query Editor
09:26 Step 3B: Query Editor, Add Status Column
11:10 a.m. Step 4: Adding a visualization to see the aging report by bins/buckets
1:00 p.m. Conclusion: final report and update files
2:13 p.m. Next steps: custom bins, trend showing number of openings and average age
#PowerBI #PowerBIQuestion #PowerBIPro
FREE step-by-step Power BI tutorial http://web.learnpowerbi.com/tutorial
Download the accompanying PBIX files for the video at https://web.learnpowerbi.com/download/
Subscribe to always receive my latest videos: https://www.youtube.com/powerbipro?sub_confirmation1
Ask questions LIVE on TalkPowerBI http://www.TalkPowerBI.com
Join our LearnPowerBI family https://www.learnpowerbi.com/training
Most popular playlists
• Power BI tutorial for beginners: https://youtu.be/AGrl-H87pRU
• Ultimate Calendar: https://goo.gl/pyki4K
• Power BI data modeling and more: https://goo.gl/WNtJFv
To light up!
-Avi Singh
http://www.LearnPowerBI.com
http://www.AviSing.com
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments