Forum Discussion
Solved
Checking for common values based on a column value
Greetings powerBI community
I have a table with two columns, Channel and Platform. We only have 2 platforms i.e. p1 and p2, I want to display a column that shows if a channel exists in both platforms should display "p1 & p2" and if it doesnt it returns its original platform. Thanks in advance
Brighton10 , Try a new column like
CONCATENATEX(summarize(filter(Table, [CHANNEL] = earlier([CHANNEL])),[Channel]), [Channel], " & ")
3 Replies
Brighton10 , Try a new column like
CONCATENATEX(summarize(filter(Table, [CHANNEL] = earlier([CHANNEL])),[Channel]), [Channel], " & ")
Hi amitchandak thanks for your reply. Its returning the same name as the channel.
Hi amitchandak thanks, I just wrote the query like this and it worked:
Desired Output = CONCATENATEX(SUMMARIZE(FILTER('Table','Table'[Channel]=EARLIER('Table'[Channel])),'Table'[Platform]),'Table'[Platform],"&")
