transformation of gantt char data to the programmer

[froxas]

Hello

I have car resertvation data as in the first table, it is usual as the gantt char option.

but I want to convert to data as in the second table. means that I want to add for each period day value 1 to each reservation.

I have to do in order to make a visual programmer (timeline) with matrix table, where only background color of the value 1 and get visual.

Does anyone have any idea how to make such a transformation?

[Greg_Deckler]

I think you want something like Open Tickets but can't be certain. https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364#M147