Forum Discussion
Remove seconds from a timestamp field
Hi Team, I am new to PowerBI and hence this question might be very simple but it would be very helpful if you help me with it. I have a field in my table "A_Timestamp" and the value is 0...
HI Anonymous
You can use the formatting features in the toolbar as Anonymous suggested.
Another option is to use the FORMAT function that allows you to control the format string. To convert your date you would use FORMAT( <datevalue> , "dd/MM/YY hh:mm" )
Phil_Seamark
Microsoft Employee
Microsoft EmployeeHI Anonymous
You can use the formatting features in the toolbar as Anonymous suggested.
Another option is to use the FORMAT function that allows you to control the format string. To convert your date you would use FORMAT( <datevalue> , "dd/MM/YY hh:mm" )
Phil_Seamark knew i missed an easy one!
Thank you so much Phil_Seamark. Thanks for your quick assistance.
- Alirezam
Helper V
Easily follow this:
in quesry view: Add column > Forma> Trim> Parse
This way you'll get rid of the seconds
