topic Generate months and milestone for a table in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Generate-months-and-milestone-for-a-table/m-p/3302536#M157421 <P>I have a following sample table with ProjectID, Milestone name and milestone date. I need<SPAN>&nbsp;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.</SPAN></P><P>&nbsp;</P><P>Sample:</P><TABLE><TBODY><TR><TD>ProjectID</TD><TD>Milestone Name</TD><TD>Milestone Date</TD></TR><TR><TD>M001</TD><TD>TROP</TD><TD>Jan-21</TD></TR><TR><TD>M001</TD><TD>EFS</TD><TD>Jun-21</TD></TR><TR><TD>M001</TD><TD>ELS</TD><TD>Jun-22</TD></TR><TR><TD>M001</TD><TD>OLS</TD><TD>Jan-23</TD></TR><TR><TD>M001</TD><TD>Lock</TD><TD>Mar-23</TD></TR><TR><TD>M001</TD><TD>RCS</TD><TD>Aug-23</TD></TR><TR><TD>M002</TD><TD>TROP</TD><TD>Feb-21</TD></TR><TR><TD>M002</TD><TD>EFS</TD><TD>Apr-21</TD></TR><TR><TD>M002</TD><TD>ELS</TD><TD>Jul-22</TD></TR><TR><TD>M002</TD><TD>OLS</TD><TD>Jan-23</TD></TR><TR><TD>M002</TD><TD>Lock</TD><TD>Mar-23</TD></TR><TR><TD>M002</TD><TD>RCS</TD><TD>Sep-23</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected output:</P><TABLE><TBODY><TR><TD>ProjectID</TD><TD>MonthCal</TD><TD>Milestone Name</TD></TR><TR><TD>M001</TD><TD>Jan-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Feb-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Mar-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Apr-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>May-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Jun-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Jul-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Aug-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Sep-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Oct-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Nov-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Dec-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Jan-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Feb-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Mar-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Apr-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>May-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Jun-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Jul-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Aug-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Sep-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Oct-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Nov-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Dec-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Jan-23</TD><TD>OLS</TD></TR><TR><TD>M001</TD><TD>Feb-23</TD><TD>OLS</TD></TR><TR><TD>M001</TD><TD>Mar-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Apr-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>May-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Jun-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Jul-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Aug-23</TD><TD>RCS</TD></TR><TR><TD>M002</TD><TD>Feb-21</TD><TD>TROP</TD></TR><TR><TD>M002</TD><TD>Mar-21</TD><TD>TROP</TD></TR><TR><TD>M002</TD><TD>Apr-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>May-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jun-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jul-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Aug-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Sep-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Oct-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Nov-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Dec-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jan-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Feb-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Mar-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Apr-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>May-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jun-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jul-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Aug-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Sep-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Oct-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Nov-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Dec-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Jan-23</TD><TD>OLS</TD></TR><TR><TD>M002</TD><TD>Feb-23</TD><TD>OLS</TD></TR><TR><TD>M002</TD><TD>Mar-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Apr-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>May-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Jun-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Jul-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Aug-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Sep-23</TD><TD>RCS</TD></TR></TBODY></TABLE> Mon, 26 Jun 2023 13:57:40 GMT Tan2912 2023-06-26T13:57:40Z Generate months and milestone for a table https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Generate-months-and-milestone-for-a-table/m-p/3302536#M157421 <P>I have a following sample table with ProjectID, Milestone name and milestone date. I need<SPAN>&nbsp;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.</SPAN></P><P>&nbsp;</P><P>Sample:</P><TABLE><TBODY><TR><TD>ProjectID</TD><TD>Milestone Name</TD><TD>Milestone Date</TD></TR><TR><TD>M001</TD><TD>TROP</TD><TD>Jan-21</TD></TR><TR><TD>M001</TD><TD>EFS</TD><TD>Jun-21</TD></TR><TR><TD>M001</TD><TD>ELS</TD><TD>Jun-22</TD></TR><TR><TD>M001</TD><TD>OLS</TD><TD>Jan-23</TD></TR><TR><TD>M001</TD><TD>Lock</TD><TD>Mar-23</TD></TR><TR><TD>M001</TD><TD>RCS</TD><TD>Aug-23</TD></TR><TR><TD>M002</TD><TD>TROP</TD><TD>Feb-21</TD></TR><TR><TD>M002</TD><TD>EFS</TD><TD>Apr-21</TD></TR><TR><TD>M002</TD><TD>ELS</TD><TD>Jul-22</TD></TR><TR><TD>M002</TD><TD>OLS</TD><TD>Jan-23</TD></TR><TR><TD>M002</TD><TD>Lock</TD><TD>Mar-23</TD></TR><TR><TD>M002</TD><TD>RCS</TD><TD>Sep-23</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Expected output:</P><TABLE><TBODY><TR><TD>ProjectID</TD><TD>MonthCal</TD><TD>Milestone Name</TD></TR><TR><TD>M001</TD><TD>Jan-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Feb-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Mar-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Apr-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>May-21</TD><TD>TROP</TD></TR><TR><TD>M001</TD><TD>Jun-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Jul-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Aug-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Sep-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Oct-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Nov-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Dec-21</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Jan-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Feb-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Mar-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Apr-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>May-22</TD><TD>EFS</TD></TR><TR><TD>M001</TD><TD>Jun-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Jul-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Aug-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Sep-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Oct-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Nov-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Dec-22</TD><TD>ELS</TD></TR><TR><TD>M001</TD><TD>Jan-23</TD><TD>OLS</TD></TR><TR><TD>M001</TD><TD>Feb-23</TD><TD>OLS</TD></TR><TR><TD>M001</TD><TD>Mar-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Apr-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>May-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Jun-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Jul-23</TD><TD>LOCK</TD></TR><TR><TD>M001</TD><TD>Aug-23</TD><TD>RCS</TD></TR><TR><TD>M002</TD><TD>Feb-21</TD><TD>TROP</TD></TR><TR><TD>M002</TD><TD>Mar-21</TD><TD>TROP</TD></TR><TR><TD>M002</TD><TD>Apr-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>May-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jun-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jul-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Aug-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Sep-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Oct-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Nov-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Dec-21</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jan-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Feb-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Mar-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Apr-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>May-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jun-22</TD><TD>EFS</TD></TR><TR><TD>M002</TD><TD>Jul-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Aug-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Sep-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Oct-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Nov-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Dec-22</TD><TD>ELS</TD></TR><TR><TD>M002</TD><TD>Jan-23</TD><TD>OLS</TD></TR><TR><TD>M002</TD><TD>Feb-23</TD><TD>OLS</TD></TR><TR><TD>M002</TD><TD>Mar-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Apr-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>May-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Jun-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Jul-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Aug-23</TD><TD>LOCK</TD></TR><TR><TD>M002</TD><TD>Sep-23</TD><TD>RCS</TD></TR></TBODY></TABLE> Mon, 26 Jun 2023 13:57:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Generate-months-and-milestone-for-a-table/m-p/3302536#M157421 Tan2912 2023-06-26T13:57:40Z