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

Copy rows with same ID

Hi guys/girls,

 

I am pretty new at powerBI 

 

Can someone help me solve this problem i would like to copy the type and sintie with the same formulierID.

 

FormulierIDvolg_nrNaamTypeDateSintie
781joepregulier3-janwada
782jaapnull3-jannull
783joopnull3-jannull
834timregulier6-janwoll
841bertpolitie3-janwazaa
851bowieregulier8-janhah
852aaanull8-jannull

 

This is how it should look like

 

 

FormulierIDvolg_nrNaamTypeDateSintie
781joepregulier3-janwada
782jaapregulier3-janwada
783joopregulier3-janwada
834timregulier6-janwoll
841bertpolitie3-janwazaa
851bowieregulier8-janhah
852aaaregulier8-janhah

 

Many thanks!!

1 REPLY 1
Super User
Super User

Re: Copy rows with same ID

Hi @tanako123

 

Try these calculated columns

I assume null means BLANK

 

Type New =
CALCULATE (
    FIRSTNONBLANK ( Table1[Type], 1 ),
    ALLEXCEPT ( Table1, Table1[FormulierID] )
)
Sintie New =
CALCULATE (
    FIRSTNONBLANK ( Table1[Sintie], 1 ),
    ALLEXCEPT ( Table1, Table1[FormulierID] )
)