Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Inflated Presence Entries in MS Power BI Table Connected to MS Dataverse #50

Open
slickspidey opened this issue Jan 24, 2023 · 1 comment

Comments

@slickspidey
Copy link

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.
Screenshot 2023-01-24 092255

@slickspidey
Copy link
Author

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant