Formats a number or date to a string.
You can choose the measure formatting for the output also in the editor field Formatting when creating a new calculated measure.
|MDX expression that returns number.|
String that defines formatting of result.
For more details (and string templates) see how to Format string content.
Example below will return a version release date as a string:
See example report Version report in our demo account. The calculated measure Predicted dates show several milestones on the timeline, including the version release date using the code above.
Here is another example of how to extract and show some numeric value. Example below will return a string value of Issue Name that follows after
- formatted to three digits. So if the Issue name is Demo-12, the returned result would be 012.