Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
nathan115
Frequent Visitor

Good Source to Learn DAX

Hi community,

I am new to Power BI, and I would like to learn more about DAX. Do you have any recommendations on a good place to start with, either books or online courses? 

1 ACCEPTED SOLUTION
stretcharm
Memorable Member
Memorable Member

There are lots of sources

 

Start here with guided learning

https://powerbi.microsoft.com/en-us/learning/

 

MS have started a new learning site. Its new so there isn't much yet, but they are adding more.

https://docs.microsoft.com/en-us/learn/browse/?products=bizapps-power-bi

 

There is a free edx course

https://courses.edx.org/courses/course-v1:Microsoft+DAT207x+1T2017/course/

 

Curbal is a fantastic chanel @ruthpozuelo has loads of videos on lots of Dax functions.

https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw

 

Powerbi tips have a good set of links to sites including learning

https://powerbi.tips/toolbox/

 

View solution in original post

11 REPLIES 11
Mukundu
New Member

  1. Most of the good sources have been highlighted already... Power query is key try out a series of Primers here: (https://bengribaudo.com/)                                                                                                                                                                         in addition 
  2. consider watching videos by Rob Kerr...https://www.youtube.com/channel/UCoQwYek1chFrTxQGhZ2jG9w   I particulary like the way he explains DAX EVALUATION CONTEXT...https://www.youtube.com/watch?v=cEc34zuEpP4 
  3. Now Macco Russo did a great job here in introducing FILTER CONTEXT in Power BI
  4. Now to really get an insight from one of the people who actually wrote DAX :Jeff Wang  try these (https://www.youtube.com/watch?v=bJtRB86n9tk  ,  https://www.youtube.com/watch?v=8v4eqssS4a4https://www.youtube.com/watch?v=k8-ti6VY_nc )
  5. Last but not the least some useful GUIDES :

                      https://dax.guide/

                      https://curbal.com/blogglossary

                      https://docs.microsoft.com/en-us/dax/

                          DAX is not a destination, Its a journey

                      

                            

Now Macco Russo did a great job here (https://www.youtube.com/watch?v=teYwjHkCEm0) in introducing FILTER CONTEXT in Power BI

najielkotob
Frequent Visitor

Hello Nathan,

 

You already got many useful resources, but you cannot get enough of DAX. Kindly check these free resources https://github.com/NajiElKotob/Awesome-Power-BI#dax don't miss the free  "Introducing DAX Course" from SQLBI and the YouTube Videos (101 and Advanced), Marco Russo and Alberto Ferrari are the best.

 

Happy Power BI'ing,

Stachu
Community Champion
Community Champion

this is a great start - short, to the point, explains most important concepts and best practices
https://www.powerpivotpro.com/wp-content/uploads/2015/10/PowerPivotPro-Reference-Card.pdf


for more advanced stuff I definately recommend sqlbi.com and their book Definitive Guide to DAX

Mastering DAX training was also very good

 



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous
Not applicable

I just wanted to add sqlbi.com

 

They have an intro video course that's free and they regularly post DAX articles to their website. It's my go-to site along with microsoft.

 

https://www.sqlbi.com/guides/dax/

I'd like to add the following great (free) DAX course from EnterpriseDNA (not affiliated)

http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax

 

DAX fridays with Ruth from Curbal.com is also a great learning source.

https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw

 

DAX Patterns is a list of common patterns to solve common problems. 

https://www.daxpatterns.com/

 

When it comes to books I would like to recommend "Supercharge Power BI: Power BI Is Better When You Learn to Write DAX" by Matt Allington. It contains a lot of exercises that will help you solidify your learning. It is a great introduction to DAX.

https://www.amazon.com/Supercharge-Power-BI-Better-Learn/dp/1615470522?tag=exccbs-20 

 

The Definitive Guide to DAX is the DAX bible. Apparently a new edition is coming out in February 2019.

https://www.amazon.com/Definitive-Guide-DAX-intelligence-Microsoft/dp/073569835X/ref=sr_1_2?s=books&...

Anonymous
Not applicable

Mastering DAX Workshop from SQLBI is probably the most in depth training I have come across/taken.  The modules are great as it helped me to not feel so overwhelemed by the amount of information.  They have quizes at the end of each section, which I found helpful.  Plus, I found them both to be entertaining and kept me interested. 

 

Combine that with their book Definitive Guide to DAX, and if you are willing to put in the time you will be much better off!

AliceW
Impactful Individual
Impactful Individual

I recommend this book on Power Query; excellent writing and helps you build your understanding on the whole system for which you need DAX. It's not just for beginners, and it takes you to an advanced level you WILL need.  

 

M Is for (Data) Monkey: A Guide to the M Language in Excel Power Query 

 

 Then you could read this one. 

Learn to Write DAX: A practical guide to learning Power Pivot for Excel and Power BI

 

stretcharm
Memorable Member
Memorable Member

There are lots of sources

 

Start here with guided learning

https://powerbi.microsoft.com/en-us/learning/

 

MS have started a new learning site. Its new so there isn't much yet, but they are adding more.

https://docs.microsoft.com/en-us/learn/browse/?products=bizapps-power-bi

 

There is a free edx course

https://courses.edx.org/courses/course-v1:Microsoft+DAT207x+1T2017/course/

 

Curbal is a fantastic chanel @ruthpozuelo has loads of videos on lots of Dax functions.

https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw

 

Powerbi tips have a good set of links to sites including learning

https://powerbi.tips/toolbox/

 

Thanks for the referral!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.