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.
The formatting of datetime in Power BI doesn't work if you only use mm:ss. Power BI will format the value as if it was MM:ss displaying Month then seconds. If I use an hour indicator, then Power BI will recongnize the lowercase mm as minutes.
MyMeasure:=TIME(0, 0, 195.6)
Has a value of "12/30/1899 12:03:16 AM"
TestFormat:=FORMAT([MyMeasure], "mm:ss")
Has a displayed value of 12:16 which is actually December and 16 seconds. If I used mmm:ss, I get Dec:16.
TestFormat:=FORMAT([MyMeasure], "hh:mm:ss")
Has a displayed value of 00:03:16, but this is actually wrong because my hh indicates a 12-hour clock and should read 12:03:16. For some reason it treats the hh as HH.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.