Forum Discussion

Johan-MTM's avatar
Johan-MTM
Helper III
2 years ago
Solved

Combine two columns

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

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.

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 

  • 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 🙂

1 Reply

  • 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 🙂