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.
Hi vijay273162
Thanks for your reply.
Great to hear that, and may I ask how you solved it? Could you share it? Thanks for your contribution to improve Power BI!
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
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.