Custom Column date formula

[Anonymous]

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 name 'FORMAT' not recognised.

New to DAX, can someone help.

Many thanks

Herbz

[pxg08680]

@Anonymous

It's working fine for me. Make it as new column.

[Anonymous]

Whats "DATEDATA"?

[pxg08680]

@Anonymous

That's a sample table name. Sorry for confusing.

[Anonymous]

Sorry, still not working.

Is there anything I need to install first before I can use these formulas?

Thanks

[pxg08680]

@Anonymous

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

Create a new COLUMN 

[Anonymous]

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 · Accepted solution]

Ok, solved the solution is 

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

[v-huizhn-msft]

Hi @Anonymous,

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

Thanks,
Angelia

[pxg08680]

@Anonymous

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