Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
1. The time duration is 1:47 but after it gets loaded into Power BI, the data showing as 0.0743055555555556. It is very difficult convert the data into duration formation which need to arrive the average time we spent.
2. The time duration is 00:01:47 but after it gets loaded into Power BI, the data showing as 12/31/1899 1:47:00 AM. It is very difficult convert the data into duration formation which need to arrive the average time we spent.
I tried to do formatting the either 1:47 or 01:47:00 but unable to to that.
Need your help to fix this.
Hi @riyaspbi
Do you import data from excel?
When I import from excel, 1:47 ->1:47:00, 00:01:47->12/31/1899 12:01:47 AM, Then I can use DateTime.Time function to extract only time value.
Best Regards
Maggie
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |