Total and not Cumulative on a selected period

[PaulMGNT]

Hi,

I have an issue creating a mesure

I have a forecast table (ordered by month ; YYYYMM).

I don't know if it's possible, I am looking for a measure to have the Total of the forecast on a selected period of month (2Months) but I need this Total forecast on all my selected period in order to decline it by wordays. (below is a exemple of what I need, third column).

Selected Period	Forecast (I have)	Total Forecast (I need)
202209	10900	12463
202210	1563	12463

tell me if you need more information.

Many thanks for you help, 

Paul

[tamerj1 · Accepted solution]

Hi @PaulMGNT 

please try

SUMX (

ALLSELECTED ( TableName[Period] ),

[Forecast]

)

[PaulMGNT]

Hi  @tamerj1 ,

that's great and simple...

Thanks a lot.

Paul,