Measure to combine values with the same row entry

[water-guy-5]

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.

[fhill · Accepted solution]

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...