formula for week of update vs campaign end date

[reibalboaOMG]

hi Everyone i'm having a problem

here's the sample date 

week of update is jan 22 - feb 12 campaign end date jan 31

what i need is a formula that will show the week number 

here's my formula : 

weeknumber = WEEKNUM('Template (2)'[Campaign End Date] - 'Template (2)'[Week of Update])

jan 22 = weeknumber 2

jan 29 = weeknumber 1

but on Feb 5 and 12/ post campaign date should be a 100% because it has reached its maximum

the expected output should be 

jan 22 : 2

jan 29 : 1

feb 5 : 1 

feb 12 : 1

[reibalboaOMG]

thank you @FreemanZ i'll try this 

[FreemanZ · Accepted solution]

hi @reibalboaOMG 

try like:

weeknumber = 

VAR _n =

WEEKNUM('Template (2)'[Campaign End Date], 2) -

WEEKNUM('Template (2)'[Week of Update], 2)

RETURN

IF(

    [Week of Update]>=[Campaign End Date],

    1, _n

)