Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Please tell me how to customize the column Time which is (HH:MM:SS) format and i want it in (MM:SS) format in power BI. What is the formula and steps to convert it ?
Solved! Go to Solution.
Hi @rajanand2807 ,
Below two options might meet your requirement.
Column = FORMAT ( MINUTE ( TB2[Time] ), "00" ) & ":" & FORMAT ( SECOND ( TB2[Time] ), "00" ) Column 2 = VAR _totalSec = HOUR ( TB2[Time] ) * 60 * 60 + MINUTE ( TB2[Time] ) * 60 + SECOND ( TB2[Time] ) RETURN INT ( _totalSec / 60 ) & ":" & FORMAT ( _totalSec - INT ( _totalSec / 60 ) * 60, "00" )
Best regards,
Yuliana Gu
Hi @rajanand2807 ,
Below two options might meet your requirement.
Column = FORMAT ( MINUTE ( TB2[Time] ), "00" ) & ":" & FORMAT ( SECOND ( TB2[Time] ), "00" ) Column 2 = VAR _totalSec = HOUR ( TB2[Time] ) * 60 * 60 + MINUTE ( TB2[Time] ) * 60 + SECOND ( TB2[Time] ) RETURN INT ( _totalSec / 60 ) & ":" & FORMAT ( _totalSec - INT ( _totalSec / 60 ) * 60, "00" )
Best regards,
Yuliana Gu
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |