Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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 , 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...
Thank you! article is very helpfull
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |