Group by with Join on 2 tables.

[Vin_1234]

Hi, 

What's the best way to achieve the below query in PowerBI.

select
c.hrms_team_level_2,
c.hrms_team_level_3,
count (i.login_name) as num_users
from
[dbo].[psdp_capacity_enrich_pdr] c
join dbo.psdp_infra_logon_connections i
on i.nt_user_name = c.nt_login
group by
c.hrms_team_level_2, c.hrms_team_level_3

[Anonymous]

Hi @Vin_1234 ,

Could you please tell me what is your desired output? I cannot understand your meaning correctly.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

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