The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
ProjectID | Milestone Name | Milestone Date |
M001 | TROP | Jan-21 |
M001 | EFS | Jun-21 |
M001 | ELS | Jun-22 |
M001 | OLS | Jan-23 |
M001 | Lock | Mar-23 |
M001 | RCS | Aug-23 |
M002 | TROP | Feb-21 |
M002 | EFS | Apr-21 |
M002 | ELS | Jul-22 |
M002 | OLS | Jan-23 |
M002 | Lock | Mar-23 |
M002 | RCS | Sep-23 |
Expected output:
ProjectID | MonthCal | Milestone Name |
M001 | Jan-21 | TROP |
M001 | Feb-21 | TROP |
M001 | Mar-21 | TROP |
M001 | Apr-21 | TROP |
M001 | May-21 | TROP |
M001 | Jun-21 | EFS |
M001 | Jul-21 | EFS |
M001 | Aug-21 | EFS |
M001 | Sep-21 | EFS |
M001 | Oct-21 | EFS |
M001 | Nov-21 | EFS |
M001 | Dec-21 | EFS |
M001 | Jan-22 | EFS |
M001 | Feb-22 | EFS |
M001 | Mar-22 | EFS |
M001 | Apr-22 | EFS |
M001 | May-22 | EFS |
M001 | Jun-22 | ELS |
M001 | Jul-22 | ELS |
M001 | Aug-22 | ELS |
M001 | Sep-22 | ELS |
M001 | Oct-22 | ELS |
M001 | Nov-22 | ELS |
M001 | Dec-22 | ELS |
M001 | Jan-23 | OLS |
M001 | Feb-23 | OLS |
M001 | Mar-23 | LOCK |
M001 | Apr-23 | LOCK |
M001 | May-23 | LOCK |
M001 | Jun-23 | LOCK |
M001 | Jul-23 | LOCK |
M001 | Aug-23 | RCS |
M002 | Feb-21 | TROP |
M002 | Mar-21 | TROP |
M002 | Apr-21 | EFS |
M002 | May-21 | EFS |
M002 | Jun-21 | EFS |
M002 | Jul-21 | EFS |
M002 | Aug-21 | EFS |
M002 | Sep-21 | EFS |
M002 | Oct-21 | EFS |
M002 | Nov-21 | EFS |
M002 | Dec-21 | EFS |
M002 | Jan-22 | EFS |
M002 | Feb-22 | EFS |
M002 | Mar-22 | EFS |
M002 | Apr-22 | EFS |
M002 | May-22 | EFS |
M002 | Jun-22 | EFS |
M002 | Jul-22 | ELS |
M002 | Aug-22 | ELS |
M002 | Sep-22 | ELS |
M002 | Oct-22 | ELS |
M002 | Nov-22 | ELS |
M002 | Dec-22 | ELS |
M002 | Jan-23 | OLS |
M002 | Feb-23 | OLS |
M002 | Mar-23 | LOCK |
M002 | Apr-23 | LOCK |
M002 | May-23 | LOCK |
M002 | Jun-23 | LOCK |
M002 | Jul-23 | LOCK |
M002 | Aug-23 | LOCK |
M002 | Sep-23 | RCS |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
95 | |
80 | |
62 | |
56 |
User | Count |
---|---|
252 | |
121 | |
112 | |
81 | |
70 |