Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Oct 20, 2022, 12:49 PM

I would like to create a calculated field in tableau to get number of working day of the month. I have used a calculation below to get working day of the months. COUNTD(IF DATEPART('weekday',[Date]) <> 1 AND DATEPART('weekday',[Date]) <> 7 THEN ([Date])

and its working fine until I am at current month. I am getting full month working day of the month but I need a calculation where for the each current month working days should calculate based on today. Please help.

Example - I need working day for October should calculate from 1st Oct to 20th Oct.

4 answers
  1. DIEGO FERNANDO MARTINEZ RODRIGUEZ (Modux)
    Oct 20, 2022, 1:13 PM

    @Roushan Srivastav​ 

    Hi, in this case you may try with:

    COUNTD(IF DATEPART('weekday',[Date]) <> 1 AND DATEPART('weekday',[Date]) <> 7 AND [Date]<=TODAY() THEN [Date] END

    If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego Martinez

    Tableau Visionary and Forums Ambassador

Write an answer...
0/9000