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
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
hi ryan_mayu thank you very much, working all rigth.
you are welcome