How to concatenate GivenName and FamilyName from Usage Metrics

[rdomingo16]

Hi Guys,

I want to create my custom usage metrics but how to concatenate GivenName and FamilyName from Usage Metrics since we could not add a new column only measure.

I am using Power BI Desktop --> Get Data --> Power BI --> Power BI Datasets --> <Your workspace> --> Report Usage Metrics Model. This model will exists once you enable the Usage Metrics of the report.

Thanks

Rudy

[v-yuezhe-msft]

@rdomingo16,

Please create the following measure.

Measure = CONCATENATE(FIRSTNONBLANK(Users[FamilyName],1),CONCATENATE(" ",FIRSTNONBLANK(Users[GivenName],1)))

Regards,
Lydia

[rdomingo16]

Hi Lydia,

Thank you for your response.

Yes that will work if you include the Family Name and the Given Name in the table, but it will not work if we use it in charts. Is there anyway to group it by Id?

Thanks,

Rudy

[v-yuezhe-msft]

@rdomingo16,

Could you please describe more details about "group by id"? You can share sample data of your table and post expected result here.

Regards,
Lydia

[rdomingo16]

Hi Lydia,

I mean group by UserGuid? Also, if I use it in charts and since it is a measure we could not put it in the x-axis. I think this should be an enhancement in the usage metrics dataset that they should include a fullname or an option that we can connect via Import. Right now, we can only connect via LIVE Query.

Thanks,

Rudy