Power BI active staff by date or date range measure
- or -
Post a project like this$100
- Posted:
- Proposals: 23
- Remote
- #2649700
- Expired
Azure Data Engineer, Power BI , SQL,ETL, SSIS and Web Site Development services
Wimbledon
34331613353916337042733758323389794342876834953123586624358239735289753263097
Description
Experience Level: Entry
Estimated project duration: less than 1 week
I'm trying to create a measure that determines who was (and how many) working at a certain time in an organization. We hire people (some repetitively) on short term contracts in different locations for different durations. Everyone has a start date an end date and a status(employed/finished/in process to start/ cancelled)
I'd like to be able to select any date or date range and be able to see who was under employment in that window...(and be able to filter that by location.)
NOTE: SOME RECORDS ARE MISSING EITHER START/END DATE OR BOTH.
I'd like to be able to select any date or date range and be able to see who was under employment in that window...(and be able to filter that by location.)
NOTE: SOME RECORDS ARE MISSING EITHER START/END DATE OR BOTH.
Brian O.
93% (3)Projects Completed
5
Freelancers worked with
4
Projects awarded
57%
Last project
11 Apr 2023
Kenya
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies