How to get list of users not being active in the last 30 days

[Anonymous]

Here is example of my data. I should get a list of users whose Exchange last active day has been over 30 days ago. The list should be uptadet if the data is updated.

[v-janeyg-msft]

Hi, @Anonymous 

According to your description, I think you can filter date in PQ using 'date filter' function, then when the data is updated, it will automatically filter the data 30 days ago.

Like this:

If it doesn't solve your problem, Please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , for that first of all create a table with unser name

user =  distinct(Table[disply name])

Join these two tables on disply name

then create a measures like this and use with user table display name

M1 =  CALCULATE(countrows(Table]) ,DATESINPERIOD('Date'[Date],MAX(Table[Date]),-30,Day)) 

measure  =

countx(values(user[display name]), if(isblank([M1]), [Diaply Name], blank()))

use the above 2 mesures , use only Measure in visual

use date table for M1

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.