The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
139 | |
110 | |
107 | |
76 | |
62 |
User | Count |
---|---|
270 | |
129 | |
123 | |
100 | |
92 |