Forum Discussion

vijay273162's avatar
vijay273162
Helper III
4 years ago
Solved

Calendar Table help

Hi All, Attached my Calendar Table for help on creating 1 Calulcated column.   https://drive.google.com/file/d/1I9cTfS9Dta6U2SrqBxCbT8Xk7OGGAStH/view?usp=sharing   Below is the snapshot of What ...
  • vijay273162's avatar
    vijay273162
    4 years ago

    Here is the solution. Hpe it helps others !!

     Create a calculated table (only taking the current Quarter Date ) in it.

    Use LOOKUPVALUE syntax, to bring the date into Business Day no. irrespective of Year.