Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Date/Time field in this format: "6/13/2017 1:47:00 PM"
I want to create a new column that displays in this format: "1pm"
The DAX function reference for Format suggests that the way to do it would be with the format string "htt", so my function looks like this:
Hour Created = FORMAT('DataTable'[Created DateTime], "htt")
But it doesn't recognize "tt" and instead of "1PM", it returns "13tt". Won't take "t" either. Also, in testing, it doesn't respect "gg", "z", "zz", or "zzz". It also treats minute characters "m" and "mm" the same as month characters "M" and "MM" (so not sure how you would isolate minutes), "y" displays the numeric day of the year, and "yyy" seems to display number of days since June 1970.
Is there a different reference sheet for the Format function as it is used in Power BI?
Solved! Go to Solution.
Hi @Anonymous,
To get hour in format "1PM", please try below formula:
Hour Created = FORMAT('DataTable'[Created DateTime], "h AM/PM")
Also, using AM/PM, am/pm, A/P, a/p can return expected result.
Best regards,
Yuliana Gu
Hi @Anonymous,
To get hour in format "1PM", please try below formula:
Hour Created = FORMAT('DataTable'[Created DateTime], "h AM/PM")
Also, using AM/PM, am/pm, A/P, a/p can return expected result.
Best regards,
Yuliana Gu
That did that trick. Where did you find it? Is there a better reference for the Power BI Format function? What would you use for minutes, since both lower and upper-case m and mm refer to month?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |