Forum Discussion
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...
Share the download link of the PBI file.
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.
Try this
Measure = SUMX(ALL(Calendar[MontYear]),[Budget])
If this does not work, then i cannot hlp any further unless i see the file.
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.