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 |
---|---|
53 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
80 | |
57 | |
40 | |
19 | |
10 |