Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
Solved! Go to 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))
)
Thank you for the quick response. Exactly what I needed.
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))
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
31 | |
26 |