Month-over-Month (MoM) Change Calculation in Power BI
Hi, I am new to Power BI and need some help with a Month-over-Month (MoM) change calculation. I receive a monthly Excel file and have included separate columns for Month and Month Order (numeric month value). Whenever a new month's file is uploaded, I want the current month's values to automatically compare against the previous month's values. My goal is to identify and highlight records where the Savings (EUR) value has changed compared to the previous month. I created the following DAX measure to calculate the previous month's savings: Previous_Month_savings =CALCULATE(SUM(Append1[Savings,EUR]),DATEADD(Append1[Month],-1,MONTH)) The Month column is a custom column that I maintain in the Excel file and update with the corresponding month name whenever I extract the data. please advise if this is the correct approach or which is the right approach.
