Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
I would like to get the average time of these timestamps:
First I have to combine all these timestamps, its a couple if thousands timestamps. I did it in excel and got the result 42777 hours and then I need to divide it with a column named "ID" and then get the average time of 42777 hours right? How do I do that the smartest way in power bi desktop?
Solved! Go to Solution.
Hi @Anonymous ,
Create a measure,not a column.
What you want is like below?
Click here (Page 2) to download pbix file if you need!
Wish it is helpful for you!
Best Regards
Lucien
Hi @Anonymous ,
Create a measure,not a column.
What you want is like below?
Click here (Page 2) to download pbix file if you need!
Wish it is helpful for you!
Best Regards
Lucien
Hi @Anonymous ,
Could you pls share your pbix file? Remember to remove the confidential information.
Best Regards
Lucien
Hi @Anonymous ,
You could try the following measure:
@v-luwang-msft Thanks you, this worked! I get the average om my timestamps now. But now i'm stuck on another thing regarding this. I got a slider where I have a date hieraki, when I try to use that slider to check between 2 dates the measure wont change. Any idea why? Should I start another thread for this maybe?
@Anonymous , refer these blog on how to deal with duration in power bi
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |