Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hey guys,
I'm trying to implement a Roll Rate analysis with Power BI, but I'm facing some challenges with the DAX measures to make it dynamic.
In concept, I want to replicate this:
https://www.listendata.com/2019/09/roll-rate-analysis.html
I want to use a matrix visual to show 30 days buckets and distribute the customers on them depending on what their status is. The rows represent the previous period (week or month) and the columns represent the current period (week or month)
I have a snapshot table that includes the status of each customer by the end of every day, the challenge I have is basically to create a dynamic calculation that helps me to put a customer on once specific cell.
I've been playing with this for days, but I haven't find a way to just use the matrix visual without creating columns or tables with the buckets, but thats where I get lost as I need the calculation to be dynamic. The user may select one specific week to see what the status was.
Any help is appreciated
Solved! Go to Solution.
I ended up doing a calculation of some extra columns to determine the datediff between the periods I needed and then creating some measures to dynamically calculate the roll rates.
how to create roll rate calculation in power bi dax
kindly provide detailed solution for creating roll rate analysis
I ended up doing a calculation of some extra columns to determine the datediff between the periods I needed and then creating some measures to dynamically calculate the roll rates.
Hello @wosscr, i am in dire need of needing to solve this exact issue, but its hard to explain, which leads to no resolution.
Can you share more details on how you resolved this??
please provide sanitized sample data.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
106 | |
75 | |
44 | |
39 | |
33 |
User | Count |
---|---|
165 | |
90 | |
65 | |
46 | |
43 |