Forum Discussion
Anonymous
7 years agoNot applicable
How to add column less then
How to add custom column which shows less then value of Column A in Column B
- Anonymous7 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
- AnonymousNot 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