title: month name not working by using format function in power bi
body: <p>I have used the following to get the stating day of the month</p>
  
  <pre><code>multiemp[Day] - WEEKDAY(multiemp[Day],2)
  </code></pre>
  
  <p>For example if my date us 22 May 2018, after using the above query, got the expected out put.i.e., 20 May 2018</p>
  
  <p>Now I tried to get the month name by using the above query and format function</p>
  
  <pre><code>format(month(multiemp[Day] - WEEKDAY(multiemp[Day],2)),"mmm")
  </code></pre>
  
  <p>results were not expected, instead of may January is getting populated.</p>
  
  <p>when verify with the following month function expected results arrived .i.e, 5</p>
  
  <pre><code>month(multiemp[Day] - WEEKDAY(multiemp[Day],2)
  </code></pre>
  
  <p>but only issue in changing the month number to month name</p>
  
  <p>Please find below:</p>
  
  <p><a href="https://i.stack.imgur.com/9bQL3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9bQL3.png" alt="enter image description here"></a></p>
  
  <p>formulas used</p>
  
  <pre><code>weekstartday = multiemp[Day] - WEEKDAY(multiemp[Day],2)
  weekstartday_month = month(multiemp[weekstartday])
  Month_name = format(multiemp[weekstartday_month],"mmm")
  another_ans = format(dateadd(multiemp[Day],-weekday(multiemp[Day],2),day),"mmm")
  another_answer_date = dateadd(multiemp[Day],-weekday(multiemp[Day],2),day)
  </code></pre>
  
  <p><strong>EDIT: Day 2</strong>
  Modified the datatype of the column to date time/timezone.</p>
  
  <p><a href="https://i.stack.imgur.com/uQl2b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uQl2b.png" alt="enter image description here"></a></p>
  
  <p>after refresh the data didn't change</p>
  
  <p><a href="https://i.stack.imgur.com/pDsNQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pDsNQ.png" alt="enter image description here"></a></p>
  
  <p><strong>Found out the solution</strong></p>
  
  <p>Solution 1:</p>
  
  <pre><code>mnname = format(multiemp[weekstartday].[Date],"mmm")
  </code></pre>
  
  <p>Solution 2:</p>
  
  <pre><code>Month_name = format(date(YEAR(multiemp[weekstartday]),MONTH(multiemp[weekstartday]),day(multiemp[weekstartday])),"mmm")
  </code></pre>
  
  <p>Thanks in advance</p>