cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arial36
Frequent Visitor

Concatenate with a calculated measure

Good morning Community:

 

I have a doubt. I'm making a dashboard that measures the usage metrics of the dashboards across the company. For this, Power BI provides a specific data set but with the problem that it does not allow access to the tables directly (as in any report) so no calculated column can be made. The issue is that in that dataset I have a column that contains the names of the users and another that contains the surname. What I need is to unify this information. If I could do calculated columns I would do it with a "CONCATENATE" and that's it, but unfortunately power BI limits the use in this dataset and I can only build calculated measures. Is there a way to do this to a measure? From already thank you very much !

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Arial36 , Actually measure we can create but will not be able to use that as a column. Because the measure would be like

= Min([First Name]) & " " Min([Last Name])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Arial36 , Actually measure we can create but will not be able to use that as a column. Because the measure would be like

= Min([First Name]) & " " Min([Last Name])



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!