Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
How can we sum this duration column and show it in metrix whereas the only count option is avaibale in drop down. Data type of this column is Time. I used sum function it didn't work for me.
Solved! Go to Solution.
@Anonymous
Create a new measure to sum the column
Dur = SUM(TableName[Duration])
and apply appropriate format
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Create a new measure to sum the column
Dur = SUM(TableName[Duration])
and apply appropriate format
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!