Discrepancy in Variance Calculation for January and February in Monthly Sheets

[garg-123]

I have actual cost sheets of 5 months and budgeted cost sheets of five months , and I need to calculate the variance between the actuals and the budgeted sheets at the material level. I must only keep the materials common in both the selected  sets of sheets; for the rest, the variance should be considered zero.

When calculating the variance, I'm getting the correct answers for March, April, and May, but the values for January and February are incorrect. I tried calculating the variance between the actuals and bugdeted sheets separately for January and February using the same procedure.

For February, I get the correct variance, but January's value is still incorrect, though it's better than the one I got from the combined variance measure.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...