Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Fiscal Week Calendar Help

Hello,

 

I want to calculate WEEKNUM but from the date I provide. 

 

Table 1:

Date:  25/07/2019

 

Table 2:

Date of Sign Up: 29/07/2019

Date of Sign Up: 02/08/2019

Date of Sign Up: 24/12/2019

 

I would like to create a column in Table 2 with WEEKNUM using the date in Table 1. 

 

How would I go about doing this.

 

 

 

Need Help

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

     

    What is the logic to be applied to put the weeknum in Table 2 based on Table 1 Value.

     

    Will Table 1 will have only one value always ?

     

    Cheers

     

    CheenuSing

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous 

       

      Table 1: is the selection of people who were sent communications. Every one was sent the communication on the same day so the date will be static. 

       

      Table 2: Is the sign ups with amount paid and othe related financial information

       

      Both tables are tables in SQL Server.

       

      Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous 

         

        Try this

         

        ByWhichWeek = Calculate(     WEEKNUM(MIN([SignUp])) 
                                  - WEEKNUM( MAX(Table1[Date])) 
                      )

        This assumes there is only one row in Table 1 and many rows in Table1 and both are not related.

         

        Is this what you expected.

         

         

        Cheers

         

        CheenuSing