Forum Discussion

patri0t82's avatar
patri0t82
Icon for Post Patron rankPost Patron
3 years ago
Solved

Ungrouping Totals

Hello, I have three columns in Power Query.. [Date], [Value] and [Count].   My first two rows, for example, are: 1/1/2023    |   Proactive   |   163 1/1/2023    |   Injections  |   3   I nee...
Need Help
  • artemus's avatar
    artemus
    3 years ago

    You can add a new custom column with

    {1 .. [Count]}

    This will create a list column of size count. You can then expand this column and delete it if you don't need the index number of each value.

artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

You can add a new custom column with

{1 .. [Count]}

This will create a list column of size count. You can then expand this column and delete it if you don't need the index number of each value.

  • patri0t82's avatar
    patri0t82
    Icon for Post Patron rankPost Patron
    3 years ago

    That's exactly it! Thank you so much