Forum Discussion
4-3-3
Helper I
Helper IHow to do character repeat in PBI
Hey guys, I am trying to get data from a rostering system. I am not sure if this is just a bad design or if that is common set up but the full day roster is broken down into 15 minute intervals start...
Greg_Deckler
Community Champion
Community ChampionWell, first I don't see how your explanation matches the data posted you mention 32/4 but I don't see that in the data you posted, I see 32,20 so I can't make heads or tails of any of that or are you saying that there are 32 commas and then 20C's or ??
But regardless, in DAX REPT is the function to repeat characters.
But regardless, in DAX REPT is the function to repeat characters.
4-3-3Helper I
Helper IHi Greg,
yeah it is a bit confusing but you are on it. The non-numeric characters mark 'activity' and the preceding number marks the amount in 15 minute intervals.
, = no activity
L = lunch
C = work
32, = 32x 15 minute intervals of no activity since midnight = 8 hours of no activity, this is kind of irrevelant here, it just means that the next activity started at 8 am
20C = 20x 15 minute intervals of work = 5 hours of work
2L = 2x 15 minute intervals of lunch break = 30 minute break
16C = 16x 15 minute intervals of work = 4 hours of work
I am trying to find out how to use the rept for each of the non-numeric characters to get to this:
,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,CCCCCCCCCCCCCCCCCCCCLLCCCCCCCCCCCCCCCC