Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Grouping, I'm not getting it

I am trying to create a table that will look like a spreadsheet for the output but because of multiple people and actions - it's duplicating dates, locations and titles for an incident like so:

 

Date of Incident   Location      What Happened   Who's involved    Correction Needed    Due Date       Status

1/24/2019               Building A   Wires Exposed    Jane Doe                    Fix wires                           1/30/2019    Completed

1/24/2019               Building A   Wires Exposed    John Doe                    Contact Supervisor   1/30/2019   Completed

 

I want it to look like this:

Date of Incident    Location     What Happened   Who's Involved   Correction Needed     Due Date        Status

1/24/2019               Building A   Wires Exposed      Jane Doe                 Fix wires                             1/30/2019    Completed

                                                                                                          John Doe                 Contact Supervisor     1/30/2019     Completed

 

I know I'm missing something somewhere but I don't know what.

 

Please advise.

 

Thanks in advance for your help.

 

 

  • Hi Anonymous 

    Glad to hear you've solved it. please accept your reply as solution, that way, other community members will easily find the solution when they get same issue.

    Regards,

6 Replies

  • Please add some sample data, prefereably a pbix file with sample data. 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Unfortunately I cannot use OneDrive or DropBox and I don't seem to have the option to upload. Plus due to the sensitive nature of the data - I couldn't send a .pbix file anyway. I sent a sample of what my data currently is doing and what I want it to do in my first  post. Did it come out at all? My report does have several tables that I've joined but I'm sure my joins are good. It should be SO simple.

      • v-cherch-msft's avatar
        v-cherch-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        Hi Anonymous 

        You may try to copy the table and use index column to filter them.Use 'Replace value' to get blank columns and append the two tables in query editor at last.For further,please check attached sample file.

        Regards.