Forum Discussion
How to calculate Total Variance for January month
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) - ...
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 3measures
1- 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]Yes, I got it, Thank you Anonymous for your help :)
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHI Anonymous
Do you have a Date (or Calendar) table in your model connected to this table?
Yes Phil_Seamark I have Snapshot Date in my table.