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] )
)