https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-to-the-last-date-according-to-the-data/m-p/1663344#M33934 <P>Hi,</P><P>Is there any way to return the last month of that recorded data? Not comparing to the current calendar month, but the month of the last recorded date</P> Fri, 12 Feb 2021 14:35:45 GMT Anonymous 2021-02-12T14:35:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-to-the-last-date-according-to-the-data/m-p/1663344#M33934 <P>Hi,</P><P>Is there any way to return the last month of that recorded data? Not comparing to the current calendar month, but the month of the last recorded date</P> Fri, 12 Feb 2021 14:35:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-to-the-last-date-according-to-the-data/m-p/1663344#M33934 Anonymous 2021-02-12T14:35:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-to-the-last-date-according-to-the-data/m-p/1663497#M33940 <P>Anonymous</LI-USER> , Try a measure like</P> <P>measure = format(maxx(allselected(Table), Table[Date]), "mmm yyyy")</P> Fri, 12 Feb 2021 15:51:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Return-to-the-last-date-according-to-the-data/m-p/1663497#M33940 amitchandak 2021-02-12T15:51:48Z