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. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Perhaps the "." after the table name cause the issue, also enclose the table name in single quote as your table namehas space in it.Try the below one.

 

Column

Est. Close Date Week = WEEKNUM('Close Date'[Date],2)

 

Thanks

Raj