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 can create a column
Column = if('Table'[Week]="Week",blank(),'Table'[Week])
then create a measure
Measure 2 = CALCULATE(max('Table'[Column]),all('Table'))
pls see the attachment below
Hi ryan_mayu thank you for the reply, but the value is not correct, the value should be Progress on maxx week on my table is 32 under Civil Trade.
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?