title: Remove weekends in a formula
body: <p>I want to remove weekends from a calculated column calculation. I am having a formula which calculate daily target: </p>
  
  <pre><code>Daily MAL Target = [MAL_Qtarget_A] /
                     (ENDOFQUARTER(Marketing_targets_MALMEL[Date]) -
                     ENDOFQUARTER(PREVIOUSQUARTER(Marketing_targets_MALMEL[Date])))
  </code></pre>
  
  <p>In the marketing Targets table thers a seperate column to identify whether the date is working day or weekday as 1 and 0.</p>
  
  <pre><code>IsWorkDay = SWITCH(WEEKDAY([Date]),1,0,7,0,1)
  </code></pre>
  
  <p>I want to add "IsWorkingDate=1" to the above Daily Mal Target formula. It is a calculated column. I have tried so many ways but could not do it.</p>
  
  <p>Can anyone help me on this?</p>