Splitting row in multiple rows by date range

[timetothink]

Hi BI community,

I am looking for a solution with row data I have, which I need to be split up in mutiple rows by a date range. 

I am getting a start and end date with a monthly value in one row from a system.

I want to get that split up in one row per month, so that I can work with those values in my reports.

Any ideas how this could be solved? Can I somehow generate a query that splits up the rows like shown below?

I appreciate any help that points me to a solution.

The source table looks something like that:

The outcome should look like this:

[timetothink]

Thank you for the quick response. Exactly what I needed.

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

https://1drv.ms/u/s!AiUZ0Ws7G26RiGuphOTM9phaNVYh?e=TSmIVh

List.Generate(
    ()=>[Start Date],(x)=>x<=[End Date],(x)=>Date.EndOfMonth( Date.AddMonths(x,1))
     )