Forum Discussion
Calendar Table help
- 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.
Hi vijay273162
To make it quicker for everyone to help you, could you please fill in each row in the picture with the expected result? Are the expected results based on Running Day - Excluding Wknd.?
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.
HI Microsoft Team,
Thanks for your reply.
I have found the answer for this problem on my own now.
Kind Request ::
Help seekers are mostly trying to get some Hints for their problem to find solution.
Hence, please make a reply ASAP.
I believe, quick response from Support Desk Team - the more customers use this platform for their organization.
Since, Tableau is offering better now-a-days.
- v-xiaotang4 years agoCommunity Support
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.
- vijay2731624 years agoHelper III
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.