Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PaulMGNT
Frequent Visitor

Total and not Cumulative on a selected period

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 PeriodForecast (I have)Total Forecast (I need)
2022091090012463
202210156312463

 

tell me if you need more information.

 

Many thanks for you help, 

Paul

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @PaulMGNT 

please try

SUMX (

ALLSELECTED ( TableName[Period] ),

[Forecast]

)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @PaulMGNT 

please try

SUMX (

ALLSELECTED ( TableName[Period] ),

[Forecast]

)

Hi  @tamerj1 ,

 

that's great and simple...

 

Thanks a lot.

 

Paul,

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.