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

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.