If, then, else with autofill?

[Marcus_S]

Hello Everybody!

I´m new in Power BI, here ist my Problem

I´ve the following table

If the Status is 1, then it´s the starting time. 2 means the ending time.

Now i try to create i visualisation tabel, that shows me in one row "Order No", "starting time", "ending time"

First i tried to create columns. but the it looks like:

Start = IF('VB Communication Log'[VB Prod_ Order Status]=1, 'VB Communication Log'[Processing at],0 )

End = IF('VB Communication Log'[VB Prod_ Order Status]=2, 'VB Communication Log'[Processing at],0 )

But in theory it must be, if status =1 then starting time, else it´s ending time.

I´ve no clue to get this.

Thanks for help

[amitchandak]

@Marcus_S , Not very clear. Try like

Start = IF('VB Communication Log'[VB Prod_ Order Status]=1, 'VB Communication Log'[Processing at],blank() )
End = IF('VB Communication Log'[VB Prod_ Order Status]<> 1, 'VB Communication Log'[Processing at],blank() )

[Marcus_S]

@amitchandak , thank for that.

Now it´s looks so

How i can get it now in one row. You see, there are rows per order. one with start and one with end. 

Thanks a lot