Splitting row in multiple rows by date range

Question

Hi BI community,&nbsp;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.&nbsp;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.&nbsp;Any ideas how this could be solved? Can I somehow generate a query that splits up the rows like shown below?&nbsp;I appreciate any help that points me to a solution.&nbsp;The source table looks something like that:&nbsp;The outcome should look like this:&nbsp;

ahmedx · Accepted Answer

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=TSmIVhList.Generate(
    ()=&gt;[Start Date],(x)=&gt;x&lt;=[End Date],(x)=&gt;Date.EndOfMonth( Date.AddMonths(x,1))
     )

Forum Discussion

Splitting row in multiple rows by date range

2 Replies

Related content

Split values in one row into multiple

Splitting columns into multiple rows

Splitting Column values

Split Data In Multiple Columns

Combine text split across multiple rows