10 Common DAX Problems & Solutions in Power BI by Chandeep Chhabra |
Excel in Excel presents #EiEFreshTalk on 10 Common DAX Formulas in Power BI by Chandeep Chhabra (Founder at Goodly.co.in)
Download the excises material used in this video: https://excelinexcel.in?ff_landing=9
Register for Upcoming #EiELearning Courses at https://excelinexcel.in/eielearning
Register for Upcoming #EiEFreshTalk at https://excelinexcel.in/eiefreshtalk
In this video:
0:00 - Getting Started
1:38 - Introduction about Mr. Chandeep Chhabra
3:08 - Introduction by Mr. Chandeep Chhabra
7:05 - Explanation of Data Model
8:48 - 1st Problem - Calculation of Fiscal year & Quarters
20:50 - 2nd Problem - Calculation of Fiscal year YTD
23:45 - 3rd Problem - Distinct from lookup table
27:52 - 4th Problem - Playing with Granularity
32:48 - 5th Problem - Displaying text in Measure
41:21 - 6th Problem - Count if
45:12 - 7th Problem - Managing Multiple dates
50:16 - 8th Problem - Growth over LY with correct totals
58:01 - 9th Problem - Select a measure using a Slicer
1:05:36 - 10th Problem - Format Function Tricks
1:11:20 - Questions and Answers session
Key Takeaways:
💡 Create simple DAX formulas to solve 10 practical business calculations in DAX.
💡 Learn and avoid the pitfalls and gotchas while writing DAX formulas.
Practice File for this session: https://chandeepchhabra-my.sharepoint...
About EiEFreshTalk:
#EiEFreshTalk is a Talk Show presented by Excel In Excel on its YouTube Channel ( / theexcelinexcel , where it will be hosting great leaders and subject matter experts (SMEs) from various fields to speak regularly on a variety of topics ranging from Excel to Analytics and Finance to Financial Modeling and many more.
These sessions are intended to offer the viewers the opportunity to listen to the esteemed speakers and interact with them to have their queries addressed.
Watch our past talks at https://www.youtube.com/playlist?list...
______________________
Register for Upcoming #EiEFreshTalk at https://excelinexcel.in/eieFreshTalk
Keep Learning on a go.
Join our Facebook Group @ / eiefreshtalk
Join our WhatsApp @ https://www.excelinexcel.in/whatsappu...
Join our Telegram @ https://www.t.me/ExcelinExcel
Visit: www.ExcelinExcel.in, an online resource center that seeks to equip users with knowledge about MS Excel with excellent content supported by examples, case studies, and short videos.
Please give this video a Like and subscribe to our channel to Learn more on MS Excel. In the comments section, please share your thoughts and let us know about things that you wish us to cover in our forthcoming videos.
Connect with us on:
Facebook at / theexcelinexcel
Twitter at / theexcelinexcel
Instagram at / theexcelinexcel
LinkedIn at / theexcelinexcel
#DAX #Calculation #multipledates
