Forum Discussion
Solved
Sum per Week
Hi good day, I need some help on my calculated column. I want the sum of forecast of each week for both area. Week1 = North forecast + SouthEast forecast Week2 = North forecast + SouthEast forecas...
Hi AllanBerces ,
You can achieve the desired output by creating a new calculated column with this DAX:
OverallForecast = VAR CurrentWeek = 'Table'[Week No.] RETURN CALCULATE( SUM('Table'[Forecast]), ALLEXCEPT('Table', 'Table'[Week No.]) )Your output will look like this:
Hi AllanBerces ,
You can achieve the desired output by creating a new calculated column with this DAX:
OverallForecast =
VAR CurrentWeek = 'Table'[Week No.]
RETURN
CALCULATE(
SUM('Table'[Forecast]),
ALLEXCEPT('Table', 'Table'[Week No.])
)
Your output will look like this:
Hi Bibiano_Geraldo MFelix Thank you very much for the reply, working perfectly
