I am looking for dax

[Ahmedkhan0503]

I have a table in whic i have 

Date and email is 

I want to create a table in which i can view the last 30 days not active emailis id and count of that emails id

Regards

Ahmed 

[amitchandak]

@Ahmedkhan0503 , for not active you should prefer an email table with distinct email ids and joined to this table.

Then create a measure like

Last 30 days  = calculate(count(Table), filter(Table, Table[Date]>=today() -30 && Table[Date]<=today()))

not active in 30  =if(isblank([Last 30 days]), 1, blank())

not active in 30  count =sumx(values(Email[Email]), if(isblank([Last 30 days]), 1, blank()))