Forum Discussion
Struggling with a Filter function
I'm not sure about the security part. Regarding the filtering, you can try the following approach:
1) Create a table with two columns: Company name and Logic (Y/N)
2) In column Logic (Y/N), put 1 if the company will use the logic and 0 if the company will not use the logic
3) Create a relationship between the new table and the original using company as a key
4) Update the Review Date Logic formula as below:
Review Status = IF (Related (Table 1 [Logic Y/N]) = 1,
IF (TODAY() >= 'Active EEs'[Next Review Date] + 30, "Over Due", "Not Yet Due"),
"N/A"))
I'm not sure about the security part. Regarding the filtering, you can try the following approach:
1) Create a table with two columns: Company name and Logic (Y/N)
2) In column Logic (Y/N), put 1 if the company will use the logic and 0 if the company will not use the logic
3) Create a relationship between the new table and the original using company as a key
4) Update the Review Date Logic formula as below:
Review Status = IF (Related (Table 1 [Logic Y/N]) = 1,
IF (TODAY() >= 'Active EEs'[Next Review Date] + 30, "Over Due", "Not Yet Due"),
"N/A"))
