Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Group By in Power Bi

Hi,

When we do the group by in Power Bi Using DAX or using Group By option from Power Query. is Power Bi creating the Virtual table?

 

 

General Comment
Need Help
Show and Tell

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks for the reply Tom. I know the difference between both.

    When we use the DAX for the group by then Power Bi creates a separate table. Is It possible to handle this using calculate measure or column?

    • TomMartens's avatar
      TomMartens
      Icon for Super User rankSuper User
      5 years ago

      Hey Anonymous ,

       

      I have to admit that I have no idea what you are trying to achieve. For this reason, please provide more information and describe your requirement in more detail..

       

      Regards,

      Tom

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hey Tom,

         

        I have achieved functionality using Summarize function but My question is when we use Group by, Summarize or SummarizeColumn DAX functions then In Power BI, it is creating an extra table.

         

        Can we achieve this using measure or calculate column which will not create an extra table.