Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a group of people that i have in a matrix table, along with a success rate for each one of them. The formula is bascially the number of events they've entered, divided by the failures. This is over a 12 month rolling timeframe. I have another visual (table) that shows the events for the current week. These events include the names as well if they have an event this for this week. I want to be able to show the 12 month rolling success rate on the row as well. This is where i'm stuck. I have the success rate shown, but it's calculated by row, therefore giving me a 100.00 all the time. Does power bi have a way to link to show the 12 month rolling succeess rate, while showing this weeks events in the same table?
@wcloninger Hard to picture what you are trying to do. Sample data and example output are ideal. This may or may not help. Better Rolling Average - Microsoft Power BI Community
Thanks for the response. Not exactly what i was looking for, but here is what i have to get you more familar with what i'm working with. I have two tables here. Eventually the top one won't be needed, i'm just using it to show my data for now. I want that column circle in red to match the other table column in red. So, if John Doe has a row at the bottom, it would have his success rate on his row. No matter how many rows that show for his name during that period with different change numbers, it should be the same success rate. FYI - the success rate is for a 12 month rolling date as well.