Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to add column less then

How to add custom column which shows less then value of Column A in Column B
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    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