Forum Discussion

unknown_anony's avatar
unknown_anony
Icon for Helper II rankHelper II
2 years ago
Solved

Groupby in a calculated column

Hello All, I am working in composite model in power bi. Used summarize function to create a import table from direct query table .  How will i group emp id and month to get the hours in one...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi unknown_anony ,
    Thanks for Sergii24  reply.
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    Create a new table

    Table 2 = 
SUMMARIZE(
    'Table',
    'Table'[Emp.ID],
    'Table'[SAP Month],
    "SUM", CALCULATE(
    SUM('Table'[Record hours]),
    ALLEXCEPT(
        'Table',
        'Table'[Emp.ID],
        'Table'[SAP Month]
    )
  )
)

    Final output

     

    Best regards,

    Albert He

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly



Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi unknown_anony ,
Thanks for Sergii24  reply.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create a new table

Table 2 = 
SUMMARIZE(
    'Table',
    'Table'[Emp.ID],
    'Table'[SAP Month],
    "SUM", CALCULATE(
    SUM('Table'[Record hours]),
    ALLEXCEPT(
        'Table',
        'Table'[Emp.ID],
        'Table'[SAP Month]
    )
  )
)

Final output

 

Best regards,

Albert He

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly