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') O...
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

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