Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyWeekly 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
AllanBercesPost Prodigy
Post ProdigyHi ryan_mayu the weekly progress is the max week value, which is on my table week 26
ryan_mayu
Super User
Super Useryou 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