https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolling12-months-query/m-p/206538#M156490 <P>Hi,</P><P>I've tried many times to create a list of the latest 12 complete months but failed, essentially I would like a funciton like</P><P><SPAN>List.Dates with syntax List.Dates(</SPAN><STRONG>start</STRONG><SPAN>&nbsp;as date,&nbsp;</SPAN><STRONG>count</STRONG><SPAN>&nbsp;as number,&nbsp;</SPAN><STRONG>step</STRONG><SPAN>&nbsp;as duration) but the&nbsp;duration can only be days, not months thus making it difficult for me. I would like todays date minus 10 days to be my starting month or ideally "YYYYMM" and then the following to be the 11 months before that. Any ideas? Thank you!</SPAN></P> Wed, 05 Jul 2017 12:28:05 GMT Anonymous 2017-07-05T12:28:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolling12-months-query/m-p/206538#M156490 <P>Hi,</P><P>I've tried many times to create a list of the latest 12 complete months but failed, essentially I would like a funciton like</P><P><SPAN>List.Dates with syntax List.Dates(</SPAN><STRONG>start</STRONG><SPAN>&nbsp;as date,&nbsp;</SPAN><STRONG>count</STRONG><SPAN>&nbsp;as number,&nbsp;</SPAN><STRONG>step</STRONG><SPAN>&nbsp;as duration) but the&nbsp;duration can only be days, not months thus making it difficult for me. I would like todays date minus 10 days to be my starting month or ideally "YYYYMM" and then the following to be the 11 months before that. Any ideas? Thank you!</SPAN></P> Wed, 05 Jul 2017 12:28:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolling12-months-query/m-p/206538#M156490 Anonymous 2017-07-05T12:28:05Z