Forum Discussion
PolarBear
6 years agoHelper I
Consecutive Weeks frequency has increased & consecutive weeks ranked in Top 10
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.
- Hi PolarBear ,You can refer to the solution of this thread:https://community.powerbi.com/t5/Desktop/Calculate-Number-of-Periods-of-Consecutive-Increase-Decrease/m-p/750974Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- V-lianl-msftCommunity SupportHi PolarBear ,You can refer to the solution of this thread:https://community.powerbi.com/t5/Desktop/Calculate-Number-of-Periods-of-Consecutive-Increase-Decrease/m-p/750974Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.