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:
Est. Close Date Week = WEEKNUM(Close Date.[Date],2)
Est. Close Date WeekNum = WEEKNUM(SUM(Close Date]),2)
Why am I not receiving the correct answer?
Solved! Go to Solution.
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.
Est. Close Date Week = WEEKNUM('Close Date'[Date],2)
Below you will see the formula I used, as well as the output of that formula. The very first row with the date of 1/15/18 should be week number 3 but I'm receiving 12. why is this?
Can you do it in the back end, or does it need to be a measure? I would just use "Column from Example" in Query Editor; it should pick up the pattern after a few entries.