Consecutive Weeks frequency has increased & consecutive weeks ranked in Top 10

[PolarBear]

I need to create either a table, column or calculated measure to determine the following metrics:

• Rank of request (based off of avg. response time, highest to lowest)
• Consecutive Week's that the avg. response time has increased (weeky avg. response time is being compared to the prior 3 month avg. response time)
• Consecutive Week's that the request has been in the top 10

I have a fact table that contains each request by time (timestamp formatted to date) and the response time of the request. I also have a date table.

[V-lianl-msft · Accepted solution]

Hi @PolarBear ,

You can refer to the solution of this thread:https://community.powerbi.com/t5/Desktop/Calculate-Number-of-Periods-of-Consecutive-Increase-Decreas... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.