Forum Discussion

chadg's avatar
chadg
Regular Visitor
2 years ago
Solved

Grouping records in table visual

I have a table visual in a report with a list of work items that are sorted by Job# and User Name. I am trying to create a lotting system for quality control that groups each set of work items into g...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    2 years ago

    Hi,

    I have used a combination of Power Query and a DAC calculated column formula to solve the problem (though this can be solved in Power Query only as well).

    PBI file attached.

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Would you be OK with a calculated column formula solution?

  • chadg's avatar
    chadg
    Regular Visitor
    2 years ago

    Ashish_Mathur  Calculated columns are fine, thank you.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      2 years ago

      Hi,

      I have used a combination of Power Query and a DAC calculated column formula to solve the problem (though this can be solved in Power Query only as well).

      PBI file attached.

      Hope this helps.