How to add column less then

[Amardeep100115]

How to add custom column which shows less then value of Column A in Column B

[v-shex-msft · Accepted solution]

Hi @Amardeep100115 ,

Current power bi not support stored multiple values in one row, you can consider to use CONCATENATE function to combine these value based on separator.

Merged =
CALCULATE (
    CONCATENATEX ( VALUES ( Table[B] ), [B], "," ),
    FILTER ( ALL ( Table ), [B] < EARLIER ( Table[A] ) )
)

Regards,

Xiaoxin Sheng