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 cumulativ progress from week 1 to last week
The Week word in the Week_column is the current week
DESIRED OUTPUT
Thank you
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
11 Replies
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 below