Forum Discussion

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

Hi,

On the data that you have shared, show the exact expected result in a simple Table format.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    This the expected result

     

    YEARDEPARTAMENT changedpromotedjoined the companyhave left
    20130000
    20142210
    20151201
    20162311

     

    Example:

     

    * Department Changed:

    ID 1 ID 1 was changed from department A to department B in 2014.

    • 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