https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Working-with-DAX-and-staff-lists/m-p/707807#M960 <P>Anonymous</LI-USER> I believe there is some sort of date/time stamp when new employee records are inserted? Can you share sample data?</P> Wed, 05 Jun 2019 15:51:19 GMT parry2k 2019-06-05T15:51:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Working-with-DAX-and-staff-lists/m-p/707798#M958 <P>Hi all</P><P>&nbsp;</P><P>I have a staff list table where a new extract is appended to the table each week with a column stating which week each extract belongs to. So if we have a staff count of 5,000 employees and the table has 4 weeks of data then you'd see 20,000 records.</P><P>&nbsp;</P><P>I would like a <STRONG>DAX expression</STRONG> that counts how many records (or employees) we see in each week and then provides an average. We have an employee number as our unique identifier e.g. 123456789.&nbsp;</P><P>&nbsp;</P><P>This will provide me with an average head count for each week.</P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 05 Jun 2019 15:37:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Working-with-DAX-and-staff-lists/m-p/707798#M958 Anonymous 2019-06-05T15:37:27Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Working-with-DAX-and-staff-lists/m-p/707807#M960 <P>Anonymous</LI-USER> I believe there is some sort of date/time stamp when new employee records are inserted? Can you share sample data?</P> Wed, 05 Jun 2019 15:51:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Working-with-DAX-and-staff-lists/m-p/707807#M960 parry2k 2019-06-05T15:51:19Z