Forum Discussion
shermayne123
Helper I
Helper ICalculate Net Working Days from dates in two different tables
Hi, I have previously used the following measure to calculate the net working days from 2 dates in the same table and was able to get the days correctly. But when I switched one of the dates to ...
Hi,
This calculated column formula in the ALL FYs table works
Column = LOOKUPVALUE('Perf metrics'[Contract Signed Date],'Perf metrics'[(PR) PR No.],'all Fys'[(PR) PR No.],'Perf metrics'[(PR) PR Item No.],'all Fys'[(PR) PR Item No.])Hope this helps.
Hi,
That error message means that there are duplicate entries appearing in the PR_REF_NO column of the System PR table.
shermayne123Helper I
Helper IHi Ashish,
Due to security issue, I won't be able to share much actual data but here's a simplified example:
All FYs table:
| (PR) PR No. | (PR) PR Item No. | Manual PR Created Date |
| ABC1000 | 1 | 3/1/2023 |
| DEF2000 | 1 | 3/2/2023 |
| DEF2000 | 2 | 3/3/2023 |
| DEF2000 | 3 | 3/4/2023 |
Perf Metrics Table
| (PR) PR No. | (PR) PR Item No. | Contract Signed Date |
| ABC1000 | 1 | 3/14/2023 |
| DEF2000 | 1 | 3/10/2023 |
| DEF2000 | 2 | 3/10/2023 |
| DEF2000 | 3 | 3/8/2023 |
So what is required is to compute the net working days between Manual PR Created Date and Contract Signed Date excluding weekends(Sat&Sun) and public holidays. Hope that is clear, otherwise feel free to let me know. Thanks so much!!
Ashish_Mathur
Super User
Super UserHi,
This calculated column formula in the ALL FYs table works
Column = LOOKUPVALUE('Perf metrics'[Contract Signed Date],'Perf metrics'[(PR) PR No.],'all Fys'[(PR) PR No.],'Perf metrics'[(PR) PR Item No.],'all Fys'[(PR) PR Item No.])Hope this helps.