Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
water-guy-5
Helper III
Helper III

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.

waterguy5_0-1651169482452.png

 

1 ACCEPTED SOLUTION
fhill
Resident Rockstar
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...

 

fhill_0-1651177144325.png

 

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




View solution in original post

1 REPLY 1
fhill
Resident Rockstar
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...

 

fhill_0-1651177144325.png

 

 




Did I answer your question, or help you along the way?
Please give Kudos or Mark as a Solution!


https://www.linkedin.com/in/forrest-hill-04480730/

Proud to give back to the community!
Thank You!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.