Forum Discussion
Solved
Weekly and Cumulative Progress
Hi good day, Can anyone help me on my measure. I have table Trade, Progress and Week_Column, What we required is 1. Calculate progress of the last week (in my table wk26) 2. Calcualate the cumulat...
updated the measure 2
Measure 2 =var _week=CALCULATE(max('Table'[Column]),all('Table'))return maxx(FILTER('Table','Table'[Column]=_week),'Table'[Progress])pls see the attachment below
you said the max week is 26, why it's 32 for Civil? could you pls more about this? I didn't see 32 in the column
is 32 a fixed number ? what if week column changed to 27? what will the week be for civil?
Hi ryan_mayu 32 is the Progress of Civil during week -26, now this week is week-27 the Progress of each trade I dont know how many they can completed by the end of this week27 which is on sunday.
updated the measure 2
Measure 2 =var _week=CALCULATE(max('Table'[Column]),all('Table'))return maxx(FILTER('Table','Table'[Column]=_week),'Table'[Progress])pls see the attachment below