Need Help in DAX!!

[Anonymous]

Hi Everyone, Is there a way where we can convert our sql code below into dax:

select distinct * from (SELECT
ROW_NUMBER() OVER (
PARTITION BY user_AuthenticatedId,FORMAT(time_stamp, 'yyyyMM')
ORDER BY time_stamp
) row_num,time_stamp,user_AuthenticatedId
FROM
gozones_users_page_view_info
)a
where a.row_num=1

Any help would be much appreciated. Thanks in Advance!

[wdx223_Daniel]

NewTable=SUMMARIZE(ADDCOLUMNS(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]))