I have a calculated column that uses this formula
Round Time = TIME(HOUR(FactWaterTankLevels[Time]), MROUND(MINUTE(FactWaterTankLevels[Time]), 30), SECOND(FactWaterTankLevels[Time]))
to convert my time column to round out to 30-minute increments. However, I want the tank levels value to show as one combined row with all of the values that fall under 12:00. Instead, it still looks like this.
Check out the CONCATENATEX command, but you'll probably have to build a TIME Table, as you'll need 1 Unique 30 minute value per CONCATENATEX join...
Check out the CONCATENATEX command, but you'll probably have to build a TIME Table, as you'll need 1 Unique 30 minute value per CONCATENATEX join...
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
