@@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
Hi there one question when you try to shorten the forma to NN:SS it shows yo the incorrect no to represent 3601 second it must be 60:01 for minutes and seconds , isn't it?
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
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?
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
I'm relaxed AND learning something new at the same time! Thank you Isabella.
You're so welcome!
wow! that was a great trick! thank you, beautiful Isabella 😘 please make more videos on DAX PBI
Thank you! Will do!
Wow, it's great! You are fabulous! You saved my life :) Thanks a lot!
Glad it helped!
This is awesome 👏👏👏
Thank you!! 😁
Nice video! Chelsie Eiden's Duration solves all these issues. You can aggregate time too.
Please tell us more about it...
@@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
Awesome! as usual, I'm flattered with your voice
LOL - thank you !!! Hope it doesn't make you fall asleep....
Hi there one question when you try to shorten the forma to NN:SS it shows yo the incorrect no to represent 3601 second it must be 60:01 for minutes and seconds , isn't it?
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
Thank you for the tutorial,
Btw why I cannot drag "Test duration 2" to Y axis after i covert follow your formula??
Hm... a bit tricky for me to trouble shoot with out looking at the specific file.
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
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?
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
Sorry I wish I can help but I'm not 100% sure...
I was trying to apply the third option but my sum went over 24 hours, so i can’t display the data labels. is there any way to solve this?
Have you tried watching this video?
czcams.com/video/xnIMJjzDKZ4/video.html
The third option is great and seemed to work at first but then my sum went over 24hours and it broke :(
modify your dax... so that the time conversion is only done at the very end.... perhaps at the total level. How did you go so far?