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

mikep7521's avatar
mikep7521
Helper III
8 years ago

The I recieve an error code: The syntax for '[Date]' is incorrect. (DAX(WEEKNUM(Installment[Close_Date][Date],2))).

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Your formula is not correct. Can you share the snapshot of your formula? Or Share the exact formula you used.

     

    Thanks
    Raj

     

    • mikep7521's avatar
      mikep7521
      Helper III
      8 years ago

      I know, thats why I'm posting on the forum. I shared the formulas above, those are the two formulas I've tried.

    • mikep7521's avatar
      mikep7521
      Helper III
      8 years ago

      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?

       

      • RMDNA's avatar
        RMDNA
        Solution Sage
        8 years ago

        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.