Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Solved! Go to 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.
Hi,
Will Week1 always start on the first day of the year?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |