Forum Discussion
Cumulative by week
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 !
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.
5 Replies
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.
Thanks a lot, it's clear and perfect !
Try this:
Cumu_Total = Calculate(Sum(Table[Budget]), Filter(All("Table[Date]"), Table[Date] <= MAX (Table[Date])))
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.
Hi,
Will Week1 always start on the first day of the year?
