Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Johan-MTM
Helper III
Helper III

Combine two columns

Hi guys,
I need your help. I want to have the same layout from this excel in a report in PBI:

JohanMTM_0-1695713862797.png

First column is library name but second column is a combination of two columns - number of loans(Antal lån) and borrower_role(Roll vid lån) where the column "Antalet lån vuxna låntagare" show number if loans done by adults.

 

To have the same layout in PBI i guess I have to combine these two columns into one (this is called calculated column right?), where number of loand done by  only adults is shown in one column.

JohanMTM_1-1695714115344.png

Would anyone be so kind and show me some dax in how this can be done? Or is there another, better way to do it?
Thanks!

edit: spelling and explaining 

1 ACCEPTED SOLUTION
Johan-MTM
Helper III
Helper III

I did a new meassure instead:

 

Antal lån vuxna låntagare =
CALCULATE( DISTINCTCOUNT( 'public loan'[id] ) ,
'public loan'[Roll vid lån] = Patron() )

 

This solved my issue 🙂

View solution in original post

1 REPLY 1
Johan-MTM
Helper III
Helper III

I did a new meassure instead:

 

Antal lån vuxna låntagare =
CALCULATE( DISTINCTCOUNT( 'public loan'[id] ) ,
'public loan'[Roll vid lån] = Patron() )

 

This solved my issue 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.