Fiscal Week Calendar Help

---

Anonymous wrote:

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

---

Hi Anonymous This seems to do the trick, thanks.

FYI: not sure if the below will make a difference to the code as it seems to work perfectly. 

There is more than one row and more than one column in Table 1, but the Date in Table 1 is static. Table 1 is communication Selection so includes what type of Comms they received, Customer ID 

Date in table 2 is dynamic. 

Table 1 and Table 2 have a relationship based on Customer ID.