Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I extracted the hour from my date field, however, the hour shows as military time. I am having trouble using the FORMAT to format for standard time. This is my new column.
Hour = HOUR([p_datetime]
This is my table. I would like for the hour to show 6 for 18, etc.
Solved! Go to Solution.
You could try it like this.
Hour = FORMAT('Table'[p_datetime],"h AM/PM")
Hi
Check these posts:
https://community.fabric.microsoft.com/t5/Desktop/Seperate-Time-from-Date/m-p/308981
https://community.fabric.microsoft.com/t5/Desktop/Get-Time-from-DateTime-field/td-p/2572372
Or use TIME function: https://learn.microsoft.com/en-us/dax/time-function-dax
TIME(HOUR([p_datetime]),MINUTE([p_datetime]),SECOND([p_datetime]))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
@Anonymous
You could try it like this.
Hour = FORMAT('Table'[p_datetime],"h AM/PM")
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
148 | |
115 | |
110 | |
102 | |
95 |