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.

Hi Anonymous

Here's a question for you. There are a few rows, around 5 that exist in table 2 but not table 1. This causes the calculation to be wrong. Is there a way to use a fixed date if (Table 1)[Date] does not exist. 

Otherwise I was thinking to add a column in the table 2 for Date as it will be static and use the below formula however the 40 is static.