Forum Discussion

asif082's avatar
asif082
Frequent Visitor
7 years ago
Solved

very urgent help needed

I needed some help with Power BI I need to merge or group by Position ID. Please see below image.   Please help with this, thanks alot....  
Need Help
  • Baskar's avatar
    Baskar
    7 years ago

    asif082

    Groupby is the solution in Power Query

Baskar's avatar
Baskar
Resident Rockstar
7 years ago

asif082's avatar
asif082
Frequent Visitor
7 years ago

okay yeah this worked thanks alot. The real data is coming from big table so I belive all I need is to use related or some dax function to extract data from master table and use group by on this new table right?

  • Baskar's avatar
    Baskar
    Resident Rockstar
    7 years ago

    asif082

    Groupby is the solution in Power Query

    • asif082's avatar
      asif082
      Frequent Visitor
      7 years ago

      Hi Basker do you know how can I group by without affecting the master table. If I group by that table it will going to impact on other reports. 

       

      Thanks one again.

      • Baskar's avatar
        Baskar
        Resident Rockstar
        7 years ago

        duplicate the table and group by. 

        If possible share the image of your report relationship