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
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.

      • DM474's avatar
        DM474
        Regular Visitor
        3 years ago

        Hi Ashish

         

        That doesnt work. 

         

        The table is above. If you assume that all I have is a table with Date and Sales Forecast, how do I calculate the Total Year out forecast?

         

        Why would you need the Power BI file to help with this? The power BI file does NOT work so would be useless.