Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous , they are measures.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous , Kindy see below.

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous , Here's the sample data.

      Sample data 

      • Anonymous's avatar
        Anonymous
        Not 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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Good day All!

    Dioes anyone of you here have an idea on how to do it?

     

    Any help is much appreciated.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi amitchandak , maybe you can help me on this one, pls. Thank you.