Trasnform Date in Rows to multiple Rows

[Haidann]

Hello guys,

I`ve a dataset like below:

hotel_id	time_from	time_to	regular
7330	7/1/2019	8/18/2019	114
1973	9/6/2019	9/14/2019	100
1973	9/16/2019	9/19/2019	100
1973	9/21/2019	12/31/2019	100
7330	9/16/2019	10/9/2019	100
7330	10/13/2019	12/31/2019	100
1973	7/31/2019	9/3/2019	100
7330	8/19/2019	9/14/2019	100
1973	9/4/2019	9/5/2019	99
1973	9/15/2019	9/15/2019	99
1973	9/20/2019	9/20/2019	99
7330	9/15/2019	9/15/2019	99
29620	8/9/2019	12/31/2019	98
359	11/3/2019	12/5/2019	80
359	10/16/2019	11/1/2019	80
359	12/8/2019	12/26/2019	80
359	12/29/2019	12/31/2019	80
359	8/16/2019	10/14/2019	80
359	12/6/2019	12/7/2019	79

How can i transform the dataset above to the template below:

hotel_id	time_from	regular
7330	7/1/2019	114
7330	7/2/2019	114
7330	7/3/2019	114
7330	7/4/2019	114
7330	7/5/2019	114
…	…	…
7330	8/18/2019	114
…	…	…
359	12/7/2019	79

Please help.

Thanks

[amitchandak · Accepted solution]

@Haidann , Refer to my blog this can help you to do :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or

Refer to this file, check how new table 2 is created: https://www.dropbox.com/s/yuv64v0cneseghx/value%20Split%20between%20months%20start%20end%20date.pbix...