Forum Discussion
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 ...
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.
vijay273162 So like this?
Current Quarter date = IF(ISBLANK([Running Day - Excluding Wknd.]),BLANK(),[Date])Hi Greg,
That's too easy....hahaha...
Here, is the problem, I'm calculating for only Business days.
So, the 64th day of Q1 FY23 is 4/4/2022 and I need to have the same on 64th day of Q1 FY22.
Snapshot error