Forum Discussion
Calculating Week by Week Figures from Weekly Collected YTD Data
Hi All,
Hoping someone can help.
I have a YTD Data set which is gathered on a week by week basis.
I want to calculate the weekly value however I need it for each Area in the data set and not an overall value.
You can see how far I have got below using the following DAX formula. Could do with a little help on how to make sure it displays the correct value for each Area.
Weekly Billable Hours =
VAR PREV_Value =
CALCULATE(Max('Act Weekly PBCS'[Billable Hours]),
'Act Weekly PBCS'[End of Week] < EARLIER('Act Weekly PBCS'[End of Week]),
REMOVEFILTERS('Act Weekly PBCS')
)
Return
If(
WEEKNUM('Act Weekly PBCS'[End of Week]) =41 ,
'Act Weekly PBCS'[Billable Hours],
'Act Weekly PBCS'[Billable Hours]-PREV_Value
)
Hoping someone can help.
1 Reply
- lbendlinSuper User
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523