---
title: DAX guided learning 101
tags: dax
---

## I. Common Patterns
- [DAX patterns](https://www.daxpatterns.com)
+ [Budget patterns](https://www.daxpatterns.com/budget-patterns/)

## II. Practice Questions
- [Practice questions from SQLBI](bit.ly/dax-practice)

## III. DAX References
DAX Documentation
- [DAX function reference, MS source](https://docs.microsoft.com/en-us/dax/dax-function-reference)
- [DAX resource center](https://social.technet.microsoft.com/wiki/contents/articles/1088.dax-resource-center.aspx)
- [Common DAX Scenarios](https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/gg399143(v=sql.110))
- [Overview of DAX by MS with SQLServer](https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/gg399181(v=sql.110))
- [DAX patterns](https://www.daxpatterns.com)

Other:
- [Power BI enterprise good and best practices](https://sqlserverbi.blog/wp-content/uploads/2019/09/power-bi-enterprise-good-and-best-practices.pdf)
- [DAX Learning Path from MS Learning Center](https://docs.microsoft.com/en-us/learn/paths/dax-power-bi/)
- [Handling BLANK value in DAX](https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/gg413463(v=sql.110)#handling-of-blanks-empty-strings-and-zero-values)

## IV. Best Practices

### Four recommended practices for new DAX-users
[Source](https://powerbi.microsoft.com/fr-fr/blog/4-recommended-practices-for-new-dax-users/)

1. Worry about the important functions first
2. Skip memorizing and focus on understanding concepts
3. Keep your functions as readabale as possible
4. Sort your measures by category

-------
Good source to learn Power BI/DAX

- Start here with guided learning: https://powerbi.microsoft.com/en-us/learning/
- New learning site from MS: https://docs.microsoft.com/en-us/learn/browse/?products=bizapps-power-bi
- Free EdX course: https://courses.edx.org/courses/course-v1:Microsoft+DAT207x+1T2017/course/
- Power BI toolbox: https://powerbi.tips/toolbox/

- [Power BI Learning Path with DAX](https://docs.microsoft.com/en-us/learn/paths/dax-power-bi/)
- [Model Data in Power BI](https://docs.microsoft.com/en-us/learn/paths/model-power-bi/)
- [Prepare Data for Analysis](https://docs.microsoft.com/en-us/learn/paths/prepare-data-power-bi/)

**References:**

- [Recommended practices for new DAX users](https://powerbi.microsoft.com/fr-fr/blog/4-recommended-practices-for-new-dax-users/)
- [Learn how to use different DAX functions in Videos](https://curbal.com/blogglossary)
- [Pareto chart in Power BI](https://powerbi.tips/2016/10/pareto-charting/)
- [DAX calculation in Power BI](https://blog.enterprisedna.co/dax-calculations-in-power-bi-best-practices/)
- [Top 10 Power BI mistakes and their best practice solutions](https://www.elegantbi.com/post/top10bestpractices)
- [DAX best practices](https://powerdax.com/dax-best-practices/)