Power BI TIME Formatting Made Simple || Convert Seconds to mm:ss or hh:mm:ss !!

Просмотров 5 тыс.

% 69

Say Goodbye to Manual Text Conversion. Don't convert your numbers into Text to get to mm:ss or hh:mm:ss. Do it the proper way in Power BI, save time and improve your efficiency !!!
In this video, I will show you how to convert your duration data from seconds to HH:MM:SS or MM:SS in Power BI in an easy and simple way.
Yes Power BI formatting option is a little limited, but there are creative ways to make the best of Power BI, such as using one of these 3 methods:
- Field Column Formatting
- Measure Dynamic Formatting
- Formatting using DAX (Format + Time Combo)
Hope you find this Power BI video useful in your learning journey.
See you next time,
Cheers,
Isabella Susilowati
@LighthouseAnalytix
#powerbi_training , #powerbitips , #powerbitutorial. #powerbitutorialforbeginners
Timeline
01:33 Fields Column Formatting
02:38 Measure Dynamic Formatting
04:52 Formatting using DAX.
Music by: www.bensound.com/free-music-for-videos
License code: 5VDRGSJQGPQGINU6
LA123

Опубликовано:

5 дек 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@jessielivermore1826 4 месяца назад

I'm relaxed AND learning something new at the same time! Thank you Isabella.

@LighthouseAnalytix 4 месяца назад

You're so welcome!

@Dansel_B 7 месяцев назад

wow! that was a great trick! thank you, beautiful Isabella 😘 please make more videos on DAX PBI

@LighthouseAnalytix 7 месяцев назад

Thank you! Will do!

@allyitaly 6 месяцев назад

Wow, it's great! You are fabulous! You saved my life :) Thanks a lot!

@LighthouseAnalytix 5 месяцев назад

Glad it helped!

@black_south5222 4 месяца назад

Hello ni would like to thank you about that video it's really helpfull , but i have a question if i have average handling time for each call per agent and i i don't want to Summarize the hall coulmn how i can do it so i can vizualize the AHT for each agent

@manojmenezes8996 4 месяца назад

This is awesome 👏👏👏

@LighthouseAnalytix 4 месяца назад

Thank you!! 😁

@gauthamk1485 6 месяцев назад

Awesome! as usual, I'm flattered with your voice

@LighthouseAnalytix 6 месяцев назад

LOL - thank you !!! Hope it doesn't make you fall asleep....

@HaroldsPurpleCrownTraining 2 месяца назад

Nice video! Chelsie Eiden's Duration solves all these issues. You can aggregate time too.

@LighthouseAnalytix 2 месяца назад

Please tell us more about it...

@HaroldsPurpleCrownTraining 2 месяца назад

@@LighthouseAnalytix Use this to iterate and aggregate: SUMX, AVERAGEX, MINX, MAXX etc. Total Late Time = VAR TotalSeconds = SUMX(railway, HOUR(railway[Late Time]) * 3600 + MINUTE(railway[Late Time]) * 60 + SECOND(railway[Late Time])) VAR Days = INT(TotalSeconds / (24 * 3600)) VAR Hours = INT(MOD(TotalSeconds - Days * 24 * 3600, 24 * 3600) / 3600) VAR Minutes = INT(MOD(TotalSeconds - Days * 24 * 3600 - Hours * 3600, 3600) / 60) VAR Seconds = MOD(TotalSeconds, 60) RETURN FORMAT(Days, "00") & ":" & FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00") & ":" & FORMAT(Seconds, "00") Simple but powerful. Chelsie Eiden at Microsoft wrote it. Google her. I always give her credit. Harold

@user-kf4kj7vd5b 4 месяца назад

Thank you for the tutorial, Btw why I cannot drag "Test duration 2" to Y axis after i covert follow your formula??

@LighthouseAnalytix 4 месяца назад

Hm... a bit tricky for me to trouble shoot with out looking at the specific file.

@priyal_001 7 месяцев назад

Can you tell me one more thing. I am taking data from SQL server and then transforming the data. But it gives me one error when I close and apply ODBC error data source error, Microsoft SQL Execution Timeout expired . The timeout period elapsed prior to the completion of the operation or the server is not responding. An unexpected exception occurred

@LighthouseAnalytix 7 месяцев назад

Sorry I wish I can help but I'm not 100% sure...

@priyal_001 7 месяцев назад

Hi I know off topic but , I have a power bi report which has a huge data model. Is there any way by which we can understand how is it created

@LighthouseAnalytix 7 месяцев назад

Absolutely... that's should be our first step whenever we want to build a Power BI report. Always start with understanding the data model. Who build it? How will it be updated? Automatically scheduled? Manually? Where does the data come from? Datawarehouse? Excel File? External data source?