Forum Discussion

Praj's avatar
Praj
Icon for Helper I rankHelper I
3 years ago
Solved

How to aggregate rows based on columns

Hello Everyone,    I have the below source table where each account has the RAG status.  I am trying to create a new output table from the above pasted table to get the unique account name a...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Praj ,

     

    Please try:

    Table 2 = DISTINCT( SELECTCOLUMNS('Table',"Account",[Account],"Status",[Status]))

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Praj ,

 

Please try:

Table 2 = DISTINCT( SELECTCOLUMNS('Table',"Account",[Account],"Status",[Status]))

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.