Forum Discussion

Marcus_E's avatar
Marcus_E
Icon for Helper I rankHelper I
6 years ago
Solved

Calculate monthly variance

Hi everyone Fairly new here to BI and am grappling with a suitable way to calculate the difference between Actual costs versus Budget costs on a monthly basis. Ideally I would like to have a DAX me...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    And with a filter it looks like this:

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

And with a filter it looks like this:

 

Marcus_E's avatar
Marcus_E
Icon for Helper I rankHelper I
6 years ago

Many thanks for the prompt solution(s). They work perfectly for what I'm trying to achieve.