Forum Discussion
Anonymous
8 years agoNot applicable
Count of Active Projects between two dates
My apologies if this exists already, i have been searching and found similar, but nothing that has worked when tested out, nor seems to fit this need. I have a table with a Project ID, Start Date...
Ashish_Mathur
Super User
4 years agoHi,
My method creates one row for each month between the beginning and ending date. You will see all steps in the Query Editor.
Anonymous
2 years agoNot applicable
Hi Ashish, I think i could use your solution as well.
Could you reshare the file where one row for every motnh was created?
- Ashish_Mathur2 years ago
Super User
Hi,
Refer to this link - Generating Rows by Month for Date Ranges in Power Query | by Daniel Marsh-Patrick | Daniel Marsh-Patrick | Medium