Forum Discussion

marmarfe's avatar
marmarfe
New Member
8 years ago
Solved

Group by - last date

Hi,    I'm quite new on the use of Power BI and I'm stuck trying to solve this probelm since almost one week.    I have a table containing registers of different flights, it looks as follow:   ...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    marmarfe

     

    Hi, in Query Editor, you can do

     

    1. Duplicate the Query

     

    2. Group By:

     

     

    3. Merge Both Tables

     

     

    4. Expand it select the columns that you desire

     

     

    5. Ready

     

     

    Regards

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

marmarfe

 

Hi, in Query Editor, you can do

 

1. Duplicate the Query

 

2. Group By:

 

 

3. Merge Both Tables

 

 

4. Expand it select the columns that you desire

 

 

5. Ready

 

 

Regards

 

Victor

Lima - Peru

  • marmarfe's avatar
    marmarfe
    New Member
    8 years ago

    Thanks Victor, It works now!!!

     

    I was focus on the columns that I wanted to have on my output table, and I never consider to link them by the ID number.

     

    Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      marmarfe,

      Glad to hear the issue is solved, you can accept appropriate reply as answer to close this thread.

      Regards,
      Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank You! Group By is an excellent solution. Much respect to your name Vverlarde. Mucas Gracias.