Forum Discussion
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...
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.
Your formula is not correct. Can you share the snapshot of your formula? Or Share the exact formula you used.
Thanks
Raj
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?
Hi mikep7521,
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.
