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. 

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.

      • mikep7521's avatar
        mikep7521
        Helper III
        8 years ago

        Could you please elaborate? I'm not familiar with what you are referencing.