Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Week Number Sequence

Hi,   I have different dates in my PowerBi and would like to assign the dates with Week 1, Week 2. The dates go from 2019 to 2021, so I want them in a sequence - like after week 53, it should be w...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    try to add a custom column using this formula:

     

    e facce sapè

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

I couldnt understand what has been mentioned. Could you let me know the process, and should I enter this on editing the power query model.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I'm not sure I understand what your difficulties are. Try copying and pasting the script into the advanced editor and see if the resulting table is what you wanted. If not, explain better what you expect.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Shall I keep the column names as it is. What should I change if I put in the advanced editor

       

      I had pasted it and it shows me error - token error.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

         

        I just copied and pasted the script and this is what I get:

         

         

        If you want help, explain more precisely and show with pictures what you did and where the error arises. Attach your advanced editor

         

        Questo il mio: