Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a calculated column that uses this formula
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.
Solved! Go to 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...
Proud to give back to the community!
Thank You!
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...
Proud to give back to the community!
Thank You!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |