Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Collecting data from multiple lines to one line

Hi colleagues,   I would like to have your support about the topic below: I have one table (summarized table) including multiple lines for each "Company" with different audit status. Is it possib...
Need Help
Tips and Tricks
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You could use SUMMARIZE or GROUPBY on your table.

     

    For example:

    SUMMARIZE (
    Table1,
    Table1[Company],
    "Audit 1", MAX ( Table1[Audit 1] ),
    "Audit 2", MAX ( Table1[Audit 2] ),
    "Audit 3", MAX ( Table1[Audit 3] ),
    "Audit 4", MAX ( Table1[Audit 4] )
)

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak First, thanks for your reply. 

    As my table is a result of "summarize" function, I can't use the "group by" ==> when i open power query my table isn't there.

    Is there any other solution please ?

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      4 years ago

      You could use SUMMARIZE or GROUPBY on your table.

       

      For example:

      SUMMARIZE (
    Table1,
    Table1[Company],
    "Audit 1", MAX ( Table1[Audit 1] ),
    "Audit 2", MAX ( Table1[Audit 2] ),
    "Audit 3", MAX ( Table1[Audit 3] ),
    "Audit 4", MAX ( Table1[Audit 4] )
)