Show multiple lines in single line per date

miqueiasrlreis 

output

this is the following logic to obtain this : 

in power query , create the table as folllowing : 

you need per to create time column . 

create a dimtime table : 

and create a table :  dimtype with type as column name . 

then: create a measure : 

Measure 3 = 

var selectedtime =  SELECTEDVALUE(dimtime[time])
var selectedtype =  SELECTEDVALUE(dimtype[type])



var res = 
SWITCH(
    TRUE(),
    selectedtype =  "Planned" , 
        var orderid = 
        CALCULATE(
        MAXx(
        FILTER(
            data1,
            selectedtime >= data1[planned start time] && selectedtime <data1[planned end time]
        ),
        data1[Order ID]
        ),
        REMOVEFILTERS(dimtime)
        )
        return orderid,

    selectedtype =  "Actual" , 
    var orderid = 
    CALCULATE(
    MAXx(
    FILTER(
        data1,
        selectedtime >= data1[actual start time] && selectedtime <data1[actual end time]
    ),
    data1[Order ID]
    ),
    REMOVEFILTERS(dimtime)
    )
    return orderid

        
   
)

return res

let me know if this works. 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠