Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,Thankyou for your valuable time, here is a list of the resource who submitted the timesheets accordingly,please find a measure which gives resources list who were submitted timesheet for all the weeks in a month,if you see A & D are the list of resource who were submitted all the weeks in july month, i need that output and one more thing that database is not capturing the data of a resource who have not submitted timesheet in that particular month/week. here "Timeshet startdate" column is a date data type and it is from 2021 to till date,and updating everyday and it is a direct query mode,please find the exact format of my data in picture and please find a measure please.
@kollasv So something like:
Measure =
VAR __Start = DATE(2022,7,1)
VAR __End = DATE(2022,7,31)
VAR __Rows = FILTER('Table',[Timesheet start date]>=__Start && [Timesheet start date]<=__End)
VAR __Weeks = COUNTROWS(DISTINCT(SELECTCOLUMNS(__Rows,"__TSD",[Timesheet start date])))
VAR __Resources =
SUMMARIZE(__Rows,[Resource name],"__WeeksSubmitted", COUNTROWS(DISTINCT(SELECTCOLUMNS(__Rows,"__TSD",[Timesheet start date]))))
RETURN
CONCATENATEX(FILTER(__Resources, [__WeeksSubmitted] = __Weeks),"[Resource name],",")
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |