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.
Solved! Go to Solution.
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?
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.