Forum Discussion
Anonymous
8 years agoNot applicable
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...
- 8 years ago
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" )
Anonymous
8 years agoNot applicable
Thank you so much Phil_Seamark. Thanks for your quick assistance.
Alirezam
6 years agoHelper V
Easily follow this:
in quesry view: Add column > Forma> Trim> Parse
This way you'll get rid of the seconds