Forum Discussion
Need Assistance
Hi Everyone,
I want to create a dax formula that will determine what tenure in days that the agent were able to achieved the proficiency level. Passing rate is >=90% and it s/b in two consecutive weeks. Just like the below image the ones highlighted in green, only 3 agents were able to achieved the proficiency level in two consecutive weeks. I only want to get the "tenure in days" in the second week. Refer to the below screen shot.
9 Replies
- AnonymousNot applicable
Hi Anonymous ,
What are the "13, 20, 27..." columns in the screenshot? Are they columns in the table or measures?
Please share some sample data and the formula that you are using.
Best Regards,
Jay
- AnonymousNot applicable
Hi Anonymous , they are measures.
- AnonymousNot applicable
Hi Anonymous , Kindy see below.
- AnonymousNot applicable
Hi Anonymous , Here's the sample data.
- AnonymousNot applicable
Hi Anonymous ,
There are several sheets in the sample data you shared. I'm not sure which data you used. Can you share the data model?
Best Regards,
Jay
- AnonymousNot applicable
Good day All!
Dioes anyone of you here have an idea on how to do it?
Any help is much appreciated.
- AnonymousNot applicable
Hi amitchandak , maybe you can help me on this one, pls. Thank you.