Weekly and Cumulative Progress

[AllanBerces]

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

[ryan_mayu]

@AllanBerces 

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])

[AllanBerces]

Hi @ryan_mayu the weekly progress is the max week value, which is on my table week 26

[ryan_mayu]

@AllanBerces 

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

[AllanBerces]

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.

[ryan_mayu]

@AllanBerces 

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

[AllanBerces]

Hi @ryan_mayu on the week column- 26 , only civil has progress during that time which is 32

Thank you

[ryan_mayu]

is 32  a fixed number ? what if week column changed to 27? what will the week be for civil?

[AllanBerces]

Hi @ryan_mayu 32 is the Progress of Civil during week -26, now this week is week-27 the Progress of each trade I dont know how many they can completed by the end of this week27 which is on sunday. 

[ryan_mayu · Accepted solution]

@AllanBerces 

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

[AllanBerces]

hi @ryan_mayu thank you very much, working all rigth.

[ryan_mayu]

you are welcome