Forum Discussion
Anonymous
3 years agoNot applicable
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
Community 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]))