https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-in-DAX/m-p/3162466#M113606 <P>Hi Everyone, Is there a way where we can convert our sql code below into dax:</P><P><BR />select distinct * from (SELECT<BR />ROW_NUMBER() OVER (<BR />PARTITION BY user_AuthenticatedId,FORMAT(time_stamp, 'yyyyMM')<BR />ORDER BY time_stamp<BR />) row_num,time_stamp,user_AuthenticatedId<BR />FROM<BR />gozones_users_page_view_info<BR />)a<BR />where a.row_num=1</P><P>&nbsp;</P><P>Any help would be much appreciated. Thanks in Advance!</P> Thu, 30 Mar 2023 05:34:50 GMT Anonymous 2023-03-30T05:34:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-in-DAX/m-p/3162466#M113606 <P>Hi Everyone, Is there a way where we can convert our sql code below into dax:</P><P><BR />select distinct * from (SELECT<BR />ROW_NUMBER() OVER (<BR />PARTITION BY user_AuthenticatedId,FORMAT(time_stamp, 'yyyyMM')<BR />ORDER BY time_stamp<BR />) row_num,time_stamp,user_AuthenticatedId<BR />FROM<BR />gozones_users_page_view_info<BR />)a<BR />where a.row_num=1</P><P>&nbsp;</P><P>Any help would be much appreciated. Thanks in Advance!</P> Thu, 30 Mar 2023 05:34:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-in-DAX/m-p/3162466#M113606 Anonymous 2023-03-30T05:34:50Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-in-DAX/m-p/3162603#M113619 <P>NewTable=SUMMARIZE(ADDCOLUMNS(<SPAN>gozones_users_page_view_info,"YearMonth",FORMAT(gozones_users_page_view_info[time_stamp],"yyyyMM")),gozones_users_page_view_info[user_AuthenticatedId],[YearMonth],"time_stamp",MIN(gozones_users_page_view_info[time_stamp]))</SPAN></P> Thu, 30 Mar 2023 06:51:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Help-in-DAX/m-p/3162603#M113619 wdx223_Daniel 2023-03-30T06:51:51Z