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
don't know how you get hte weekly progess output. Could you pls elaborate the calculation logic?
for the second column, you can try this
Measure = sumx(FILTER('Table','Table'[Week]<>"Week"),'Table'[Progress])
Hi ryan_mayu the weekly progress is the max week value, which is on my table week 26
you can create a column
Column = if('Table'[Week]="Week",blank(),'Table'[Week])then create a measureMeasure 2 = CALCULATE(max('Table'[Column]),all('Table'))pls see the attachment belowHi 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.