Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
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
Solved! Go to Solution.
try like:
try like:
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |