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:   D...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

Gopal30's avatar
Gopal30
Icon for Helper I rankHelper I
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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
      7 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'll give it a whirl.

         

        Thank you!