stuartridout
Inflated Presence Entries in MS Power BI Table Connected to MS Dataverse
I am trying to use MS Power BI to create a table that displays the office presence status of employees in my organization, as recorded in the "cr599_presence" table in MS Dataverse. However, the table is showing inflated numbers for some employees and I am not sure why. I am trying to show a count of the unique presence entries for each staff member, but some are showing more than the expected 5 entries for a week. Can you help me understand why this is happening or how to correctly show the count of presence entries for each employee? I have included an image for reference of what I'm trying to create with MS Power BI.
Also, I am using the "Email" column as a unique identifier for each employee in the rows of my table because it provides the most accurate count of their presence. When I used the "Created By" and "Modified By" columns, the count for everyone's presence was significantly inflated, particularly for myself for some reason.