Forum Discussion
Solved
Split per month recurrent values
Hi! I have a doubt of how to build a report. I have a table where I can find diferent lines related to item which has the following structure: - Item code - Date valid From -Date Valid to - Mon...
Hi MigCua ,
Add a new custom column in Power Query like this:
List.Distinct( List.Transform( {Number.From([Date valid from])..Number.From([Date valid to])}, each Date.StartOfMonth(Date.From(_)) ) )This should give you a nested list of the first of each month on each row.
Expand this list to new rows and you'll have everything you nee to report as required.
Pete
Hi MigCua ,
Difficult to say what needs to be done without more info.
What error do you get when you try and use this code?
If you can share some anonymised sample data in a copyable format here (paste table from Excel, or provide M code from an 'Enter Data' query) I can create the steps for you.
Pete
