Cumulative by week

[Levent]

Hello,

Anybody can resolve my problem ? 

I want to get the budget of project by week with DAX.  I have startDate and endDate. But i can't calculate realtive to week.. I tried by month with TOTALMTD but it's not good result.

Thanks a lot for your responses !

[Ashish_Mathur]

Hi,

Will Week1 always start on the first day of the year?

[v-frfei-msft · Accepted solution]

Hi @Levent ,

One sample for your reference, Please check the following steps as below.

1. Create a Calendar table and insert a calculated column in it.

Calendar = CALENDARAUTO()

Week = "Week" & WEEKNUM('Calendar'[Date])

2. Create a measuare to get the excepted result.

Measure = 
CALCULATE(SUM(Porjects[Budget]),FILTER(Porjects, Porjects[DateEnd]>=MIN('Calendar'[Date])))

Pbix as attached.

[Levent]

Thanks a lot, it's clear and perfect !

[Gopal30]

Try this:

Cumu_Total = Calculate(Sum(Table[Budget]), Filter(All("Table[Date]"), Table[Date] <= MAX (Table[Date])))

[Levent]

Thank for your response. 

It's not just cumulating in time week by week.

But I need to cumulate only the budgets that have a start and end date in the first day of the week.