Hello, I am struck at how can we calculate the total variance for January month for a particular project. I came to know that the total variance for January month = (Current month Variance) - (Baseline Dec month Variance)I have Variance columns in the table. How can I create calculation part to get the total variance for a particular project?Help needed, thanks in advance. Bhavesh

If you do not have a date table, you need to create a date table (Date dimension) and connect your snapshot date to the date in newly created date table. Then create 3measures1- YTD Current Month := TOTALYTD(SUM('Project Costs'[Variance]), Date[date])2- YTD Prior Month := CALCULATE( [YTD Current Month], PREVIOUSMONTH(Date[Date]))3- MTD (January) := [YTD Current Month] - [YTD Prior Month]

How to calculate Total Variance for January month

Forum Discussion

Related content

Variance calculation dex

Calculate average variance

Calculation Groups, Variances, Slicers

Dynamic Format DAX measure calculating variance

Calculating Variance