Need help in dax!!

[Anonymous]

Hello Everyone, how can we convert our sql code below into DAX!!

select distinct a.*
from (select distinct user_AuthenticatedId , time_stamp
from gozones_users_page_view_info where (month(time_stamp)=(month(GETDATE()))) and year(time_stamp)=year(GETDATE()))a
join 
(select distinct user_AuthenticatedId  
from gozones_users_page_view_info where (month(time_stamp)=(month(GETDATE())-1)) and year(time_stamp)=year(GETDATE()))b
on a. user_AuthenticatedId=b.user_AuthenticatedId

Any help would be much appreciated. Thanks in Advance!!

[lbendlin]

Describe the business problem you are trying to solve and provide sample data and expected output.