Forum Discussion
Measure to combine values with the same row entry
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...
1 Reply
- fhill
Resident Rockstar
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...