Tutorial with DAX formulas on Power BI rolling averages in to compare calculations over weekly, monthly, or quarterly intervals. Tutorial to calculate a rolling average in Power BI, using 7 days, 30 days, quarters and years as time […]
In this Power BI tutorials section, we propose DAX functions scripts examples to calculate different values in SSAS Cube in tabular mode or Power BI reports. DAX functions are also called DAX Formulas.
The Microsoft DAX language is the base programming language for SQL Server Analysis Services in tabular mode, Power BI desktop or service and also in Excel PowerPivot.
The type of functions available, for example :
– Date and time functions
– Time-intelligence functions
– Filter functions
The available articles so far are:
DAX formula to calculate the YTD value of a Power BI measure. Power BI tutorial on how to calculate the YTD value using a DAX formula. To create a YTD type measure using Power BI, use the TOTALYTD
Power BI tutorial on how to use the SAMEPERIODLASTYEAR function in a DAX formula to calculate the last year value. To calculate the previous year value in a Power BI formula, simply use the two available DAX CALCULATE
How to create a calculation of the previous month value using DAX formulas in Power BI? Discover how to calculate the Power BI previous month value in this tutorial using 2 different approach’s. Managers, Accountants, Financial advisors and