Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need Help in DAX!!

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!

1 Reply

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion

    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]))