Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 conve...
Need Help
  • fhill's avatar
    fhill
    4 years ago

     

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

     

     

     

fhill's avatar
fhill
Icon for Resident Rockstar rankResident Rockstar
4 years ago

 

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