--- title: Introduction to DAX - Part 4 - References tags: dax-foundation-course --- # Some notes on DAX ## 1. 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) - [Pareto chart in Power BI](https://powerbi.tips/2016/10/pareto-charting/) :question: [How to hide future dates for date-time calculation?](https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/) ## 2. Best Practices - [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) - [DAX calculation in Power BI best practices](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/) - [DAX best practices](https://maqsoftware.com/insights/dax-best-practices) ### Four recommended practices for new DAX-users [Source](https://powerbi.microsoft.com/fr-fr/blog/4-recommended-practices-for-new-dax-users/) **Worry about the important functions first** ![](https://powerbicdn.azureedge.net/mediahandler/blog/media/PowerBI/blog/fd475e92-46d1-49f8-a127-9974083a67e6.png) **Skip memorizing and focus on understanding concepts** ![](https://powerbicdn.azureedge.net/mediahandler/blog/media/PowerBI/blog/043cc259-193b-4fb6-ad2e-12879138020e.png) **Keep your functions as readabale as possible** ![](https://powerbicdn.azureedge.net/mediahandler/blog/media/PowerBI/blog/fe4f0b53-c711-49f7-be29-7687cfeccbe3.png) **Sort your measures by category** ![](https://powerbicdn.azureedge.net/mediahandler/blog/media/PowerBI/blog/7e0003a7-e8a1-4287-88f9-c3b67eaa2b15.png)