Generate rows for month/year between a range of dates

[luzsoulez]

I need something that gives me just the month and year (it can be the first day of the month or last as long as it is not Saturday or Sunday) to be able to calculate revenue per month. See row 2. I basically need to repeat the 41,044 for every month between Jan 2022 and Dec 2024

This is what I tried but it is not working

Table.AddColumn(#"Reordered Columns", "Transaction Date", each List.Select( List.Transform( {Number.From([Start Date])..Number.From([End Date])}, each Date.From(_) ), each Date.EndofMonth(_, 1) ))

[ImkeF · Accepted solution]

Hi @luzsoulez ,
please check out the function that I've published here: Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query – The BIccountant

[luzsoulez]

Thanks that worked! Brilliant 🙂