Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Custom Column date formula

Hi All,   I am trying to create a custom formula to with a 3 digit month.   I am using the forumla = FORMAT([Payment Date],"mmm")   I am getting the following message "Expression Error : The na...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Ok, solved the solution is 

     

    Date.ToText([#"Payment Date"],"MMM")

pxg08680's avatar
pxg08680
Resolver III
8 years ago

Anonymous

Close your Power Bi (if desktop version). Re-open and try doing the same.

Create a new COLUMN 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Ok, getting warmer (new at this).

 

What seems to work is this expression.....Number.ToText(Date.Month([#"Payment Date"])), but this gives me a month number. How do I translate this into 3 digit month name?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Ok, solved the solution is 

     

    Date.ToText([#"Payment Date"],"MMM")

    • pxg08680's avatar
      pxg08680
      Resolver III
      8 years ago

      Anonymous

      Can you mark your post as Solved so that some one can use it later.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi Anonymous,

      Please mark your solution as answer, so more people wull benefit from here.

      Thanks,
      Angelia