Power BI

Last year value in Power BI with DAX

With Power BI, how to calculate the last year value in DAX? Simply use the two available DAX CALCULATE function combined with the PREVIOUS YEAR function. In financial dashboard and reports, use the previous year value for comparison and variance calculation with the current year. Indeed analyzing financial figures is often about time comparison and rolling forecasts. Financial forecast uses rolling months, quarters or

Power BI

Power BI previous month value with a DAX formula

With Power BI, how to calculate the previous month value using DAX formulas? Managers, Accountants, Financial advisors and Business consultants use Power BI and month comparisons extensively, like the previous month values and the last year values. To create these comparison measures, use the DAX time intelligence functions available in the DAX editor. Let’s use the PREVIOUS MONTH DAX function to address this. How

Power BI

Calculate the YTD value in Power BI (Year-To-Date with DAX formula)

DAX formula to calculate the YTD value of a Power BI measure. Example of formula to calculate the YTD value with Power BI, abbreviation of the Year-To-Date value, it represents the total to date of a given measure, i.e., from the beginning of the year to the current date. The YTD value can be based on a fiscal calendar or on a regular Gregorian