cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Amardeep100115 Regular Visitor
Regular Visitor

How to add column less then

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

Accepted Solutions
Community Support Team
Community Support Team

Re: How to add column less then

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

Re: How to add column less then

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |