Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI @hammout,
AFAIK, current power bi data model table does not support duration type time values.
For this scenario, you can try to convert them to numeric ‘total second’ at first for following aggregation calculations. Then you can manually divide them to different time levels and concatenate them back to duration format with text type.
You can also take a look at the following blog about aggregation duration/time values if help:
Aggregating Duration/Time - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
HI @hammout,
AFAIK, current power bi data model table does not support duration type time values.
For this scenario, you can try to convert them to numeric ‘total second’ at first for following aggregation calculations. Then you can manually divide them to different time levels and concatenate them back to duration format with text type.
You can also take a look at the following blog about aggregation duration/time values if help:
Aggregating Duration/Time - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |