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 ...
Need Help
Show and Tell
Tips and Tricks
  • 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.

     

vijay273162's avatar
vijay273162
Helper III
4 years ago

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-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

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.

  • vijay273162's avatar
    vijay273162
    Helper III
    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.