---
# System prepended metadata

title: Introduction to DAX - Part 4 - References
tags: [dax-foundation-course]

---

---
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)
