Forum Discussion

DM474's avatar
DM474
Regular Visitor
3 years ago

Sum for Projected Year total

I am sure this is really simple but for some reason I just cannot get this right.    I have a table showing sum(x) for each month, sum(x) YTD, and sum(x) FYTD. Easy.    I need to add the Total ye...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share some data and show the expected result.

DM474's avatar
DM474
Regular Visitor
3 years ago

See below. The first column shows monthly budget, second is the cumulative budget over the fyear. The third column should always show the EOY budget, ie. 9,341,386.61

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Share the download link of the PBI file.

    • DM474's avatar
      DM474
      Regular Visitor
      3 years ago

      Hi Ashish

       

      I just want help with the generic formula, I cannot share the file. 

       

      It should be a simple formula to calculate the whole year. 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        3 years ago

        Try this

        Measure = SUMX(ALL(Calendar[MontYear]),[Budget])

        If this does not work, then i cannot hlp any further unless i see the file.