Forum Discussion

karkar's avatar
karkar
Helper III
9 years ago
Solved

Summarization

Hello,   I have the following table as a result of a SQL query in Power Bi and after i created a measure to have distincts by ID and value. I now want to be able to create another table out of it ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    karkar

     

    Hi, Go to Edit Query and Use Group By (in Transform Tab).

     

    Follow the steps:

     

    Group By

    Regards,

     

    Victor

    Lima - Peru

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

karkar

 

Hi, Go to Edit Query and Use Group By (in Transform Tab).

 

Follow the steps:

 

Group By

Regards,

 

Victor

Lima - Peru

  • karkar's avatar
    karkar
    Helper III
    9 years ago

    Thanks you Lima. That was so nice of you to have it in the form of a video. It helps a lot and is what i wanted also.

    Just curious , can this also be done using DAX? If so how and which one do you prefer?

     

    Thanks

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      karkar

       

      In Dax is also possible.

       

      To Create New Tables Using a original table i prefer Query Editor. They insert in to the model.

       

      But if you want to just show in a visual (Not Create a table) with DAX is very simple to obtain.