Forum Discussion

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Your and my answers for Department changed do not match for 2015 and 2016.  For 2015 and 2016, the answer should be 3 (see screenshot below) and revise the answers that you have shared.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Excuse me, if you're right with your answer. How can I recreate this dax? you share that .PBIX

 

Thanks

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    You have not answered my question.  Am I correct in the statement that I made in the previous post?  Also, review your expected answers and make corrections.  Share the updated expected result table.  I'd like to share the PBI file only after I have computed all measures.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I Excusme again. Your statement is correct and the distribution you propose is true.

       

       

      This is the Expected Result

       


      Year      		1. Changed Department2. Nivel Changed3. Joined the Company4. Have Left
      20130000
      20142210
      20153201
      20163311
      Total8722
      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        6 years ago

        Hi,

        You may download my PBI file from here.  I have not understood the second question so have left that.

        Hope this helps.