Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Tan2912
New Member

Generate months and milestone for a table

I have a following sample table with ProjectID, Milestone name and milestone date. I need generate a new table or modify the existing table which generates with months in between two milestone, and populate milestone names till the next milestone occurs, by ProjectID.

 

Sample:

ProjectIDMilestone NameMilestone Date
M001TROPJan-21
M001EFSJun-21
M001ELSJun-22
M001OLSJan-23
M001LockMar-23
M001RCSAug-23
M002TROPFeb-21
M002EFSApr-21
M002ELSJul-22
M002OLSJan-23
M002LockMar-23
M002RCSSep-23

 

Expected output:

ProjectIDMonthCalMilestone Name
M001Jan-21TROP
M001Feb-21TROP
M001Mar-21TROP
M001Apr-21TROP
M001May-21TROP
M001Jun-21EFS
M001Jul-21EFS
M001Aug-21EFS
M001Sep-21EFS
M001Oct-21EFS
M001Nov-21EFS
M001Dec-21EFS
M001Jan-22EFS
M001Feb-22EFS
M001Mar-22EFS
M001Apr-22EFS
M001May-22EFS
M001Jun-22ELS
M001Jul-22ELS
M001Aug-22ELS
M001Sep-22ELS
M001Oct-22ELS
M001Nov-22ELS
M001Dec-22ELS
M001Jan-23OLS
M001Feb-23OLS
M001Mar-23LOCK
M001Apr-23LOCK
M001May-23LOCK
M001Jun-23LOCK
M001Jul-23LOCK
M001Aug-23RCS
M002Feb-21TROP
M002Mar-21TROP
M002Apr-21EFS
M002May-21EFS
M002Jun-21EFS
M002Jul-21EFS
M002Aug-21EFS
M002Sep-21EFS
M002Oct-21EFS
M002Nov-21EFS
M002Dec-21EFS
M002Jan-22EFS
M002Feb-22EFS
M002Mar-22EFS
M002Apr-22EFS
M002May-22EFS
M002Jun-22EFS
M002Jul-22ELS
M002Aug-22ELS
M002Sep-22ELS
M002Oct-22ELS
M002Nov-22ELS
M002Dec-22ELS
M002Jan-23OLS
M002Feb-23OLS
M002Mar-23LOCK
M002Apr-23LOCK
M002May-23LOCK
M002Jun-23LOCK
M002Jul-23LOCK
M002Aug-23LOCK
M002Sep-23RCS
0 REPLIES 0

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.