Help creating weekly snapshot table

[nb123nb]

Hi there,

I have an Excel online document I am using as my data source.

The table is called 'Capability' and each team adds a new row to it every 6-8 weeks where they rate themselves for themes of Flow/Value/Culture/Delivery:

I want to create a new table that each week will show me what %of teams were Red/Amber/Green for each theme of Flow/Value/Culture/Delivery. Based on whatever their most recent rating was. I'm guessing this should be some form of 'snapshot' table?

[Ritaf1983]

Hi @nb123nb 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

[nb123nb]

Sure thing - https://drive.google.com/file/d/19BqkiY63L6KqE8OoDwL6_ToDOin6mQgF/view?usp=drive_link is an empty report with the raw data structure still in place