Show Users with NO values for last 3 month

[yakovlol]

Hello!

Could you please help me to create a measure that will show Users and their Projects with no values for the last 3 month?

I have a matrix like below. And I want to leave in a table only the user_id in this example 2 and project_id 21,22 where is no values for the last 3 months 

Based on my Tables if user have no value there is no record in my table. I'm sowing No values with "Show data with no values"
For the months in column i'm using Calendar table.

Attaching the link to pbix.file

Could you please help if there is any chance to get such users with no values for last Xmoths?

Thank you for any suggestions.

[amitchandak · Accepted solution]

@yakovlol , Create a measure like , with help from date table joined with date of your table

Rolling 3 = CALCULATE(Countrows(Table),DATESINPERIOD('Date'[Date ],MAX('Date'[Date]),-3,MONTH))

Then create a measure like

not present =  if(Isblank([Rolling 3]), "Not Present", "Present")

not present = countx(values(Table[User]), if(isblank([Rolling 3]), [User], blank() ) )

refer

Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

[yakovlol]

Thank you! article is very helpfull