Forum Discussion

Brighton10's avatar
Brighton10
Helper II
4 years ago
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 platform...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Brighton10 , Try a new column like

     

    CONCATENATEX(summarize(filter(Table, [CHANNEL] = earlier([CHANNEL])),[Channel]), [Channel], " & ")

Brighton10's avatar
Brighton10
Helper II
4 years ago

Hi amitchandak thanks for your reply. Its returning the same name as the channel. 

Brighton10's avatar
Brighton10
Helper II
4 years ago

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],"&")