Forum Discussion
Helper IConcatenate Following Line with Previous One in PowerBi
Hi Sir
The Second solution works, whereas the first one needs a tweek, It concatenates two valid transactiions if on the same date when it should not. Refer to 21 Oct ( Still in Solution 1).
Solution 2 seems to work perfectly. Kudos, kudos.
Super UserHi JaweedL
there are two options in the attached pbix. The first one fills down the date in power query and uses concatenatex to combine row values
the second one uses a index column to pick the row value that is either of a higher or lower value than the current index.
they will work given the sample data but if there are more than two blank consecutive rows, the formula will return an incorrect result for the second option.
Helper IHi Sir
The Second solution works, whereas the first one needs a tweek, It concatenates two valid transactiions if on the same date when it should not. Refer to 21 Oct ( Still in Solution 1).
Solution 2 seems to work perfectly. Kudos, kudos.