Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I am wondering how to format today function to a string/text
Hi @ph
Try for example:
FORMAT(TODAY();"DD-MM-YYYY")
The DAX guide entry for FORMAT does have a link to the supported formats. Check these out:
https://docs.microsoft.com/en-us/dax/pre-defined-date-and-time-formats-for-the-format-function
https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function
Please mark the question solved when we get to the solution and consider kudoing if posts are helpful.
Cheers
Hi @AlB
thanks for tip, but it doesn t work 😞
it will display it in mentioned format, but still it is not string
I need in string as a input to next calculation where string is required
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |