Forum Discussion

mikep7521's avatar
mikep7521
Helper III
8 years ago
Solved

Week Number for a certain date

I'm attempting to create a column/measure that captures what weeknum a certain date is in but i'm not receiving the correct answer. Below is my column and measure formula: Column Est. Close Date We...
Need Help
  • mikep7521's avatar
    mikep7521
    8 years ago

    I figured out the issue. There were multiple installments that had the same closing date whcih is what was leading to the wrong values being displayed. 

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi mikep7521

There is something wrong with your formula, please look at the following test and correct your formula.

Calculated column

weeknum = WEEKNUM([Close Date],2)

 

Measure

Measure = WEEKNUM(MAX([Close Date]),2)

 

 

Best Regards

Maggie