Forum Discussion
Solved
Splitting row in multiple rows by date range
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...
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)) )
Thank you for the quick response. Exactly what I needed.