https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Variance/m-p/694512#M648 <P>Hi All,</P><P>&nbsp;</P><P>I have a dataset with employee names;</P><P>&nbsp; &nbsp; &nbsp;&nbsp;</P><P><U>ID&nbsp; &nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Month</U></P><P>1&nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/03/19</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/03/19</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; Chris&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/03/19</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/19</P><P>5&nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/04/19</P><P>6&nbsp; &nbsp; &nbsp; &nbsp; Mike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/19</P><P>&nbsp;</P><P>I am trying to create a visualisation that will show leavers and joiners between two dates. So if the user selects between 01/03 and 01/04 they would see that Chris has left and Mike has joined. Can anyone suggest the easiest way to go about doing this?</P><P>&nbsp;</P><P>Many Thanks,</P><P>&nbsp;</P><P>Mark&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 May 2019 05:05:44 GMT MWilson929 2019-05-20T05:05:44Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Variance/m-p/694512#M648 <P>Hi All,</P><P>&nbsp;</P><P>I have a dataset with employee names;</P><P>&nbsp; &nbsp; &nbsp;&nbsp;</P><P><U>ID&nbsp; &nbsp; &nbsp; &nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Month</U></P><P>1&nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/03/19</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/03/19</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; Chris&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/03/19</P><P>4&nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/19</P><P>5&nbsp; &nbsp; &nbsp; &nbsp; Sarah&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/04/19</P><P>6&nbsp; &nbsp; &nbsp; &nbsp; Mike&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/19</P><P>&nbsp;</P><P>I am trying to create a visualisation that will show leavers and joiners between two dates. So if the user selects between 01/03 and 01/04 they would see that Chris has left and Mike has joined. Can anyone suggest the easiest way to go about doing this?</P><P>&nbsp;</P><P>Many Thanks,</P><P>&nbsp;</P><P>Mark&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 May 2019 05:05:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Dynamic-Variance/m-p/694512#M648 MWilson929 2019-05-20T05:05:44Z