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

     

sanalytics's avatar
sanalytics
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

You can also acheive your  output through Power Query..Attached is the screenshots and Power Bi file..

 

https://dropfiles.org/p7Cp8b


have a look

 

Regards

sanalytics