For more details regarding this recipe, refer to the following links:
- Data Analysis Expressions (DAX) in Power Pivot: https://support.office.com/en-us/article/Data-Analysis-Expressions-DAX-in-Power-Pivot-BAB3FBE3-2385-485A-980B-5F64D3B0F730
- DAX basics in Power BI Desktop: https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics
- Getting started with the DAX queries for SQL Server Analysis Services: https://www.mssqltips.com/sqlservertip/4068/getting-started-with-the-dax-queries-for-sql-server-analysis-services