Forum Discussion
Power query insert rows in between based on number of days between moths.
Hi! I am not sure if power query is the best way to do this… But I want to insert/copy X new rows in between already existing rows based on the number of days between the dates. Please see pic f...
Victor107200 Difficult to help without a file with your data. But you would want to add a calendar table (one with every day of the year). Then you need to transform the "Attribut" column to the first day of the month and data type is as a date. As per your screenshot it's a text (ABC). Then merge data with the calendar table and fill down.
If you run into trouble, come back here.
Go kväll!