Forum Discussion

stephr's avatar
stephr
Regular Visitor
6 years ago
Solved

Sum of one specific value with multiple values in a cell

Hi,   I have a table looking like this : content pageviews M01 12 M02,M03 8 M01, M02, M03 4 M03 2   I would like to create a table with the sum of each "M", the result w...
  • Fowmy's avatar
    Fowmy
    6 years ago

    stephr 

    In Power Query, go to your table. right-click on the content column and choose, split column by delimiter, and choose By Row under advanced, Then, Right-click on the  content column and select Group By

     

     

    ________________________

    Did I answer your question? Mark this post as a solution, this will help others!.

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube, LinkedIn

     

     

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

stephr - I would suggest splitting your first column and then probably unpivoting in Power Query.

 

Otherwise, if you have a disconnected table with M01, M02, etc. you could do this:

pageviews measure = 
  VAR __Content = MAX('DisconnectedTable'[Content])
  VAR __Table = ADDCOLUMNS('Table',"Include",IF(FIND(__Content,[Content],,0)>0,1,0)
RETURN
  SUMX(FILTER(__Table,[Include]=1),[pageviews])