Creating A Missing Timesheets Table

Question

I have some timesheet data for my company and I am trying to create a visual that will report wheather a specific employee has missing timesheets.&nbsp;&nbsp;The primary data table looks something like this...&nbsp;&nbsp;Name&nbsp; &nbsp; Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LineTask&nbsp; &nbsp; &nbsp; &nbsp; HoursA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/01/2022&nbsp; &nbsp; &nbsp; &nbsp;Meetings&nbsp; &nbsp; &nbsp; 8B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/01/2022&nbsp; &nbsp; &nbsp; &nbsp;Meetings&nbsp; &nbsp; &nbsp; 8A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/02/2022&nbsp; &nbsp; &nbsp; &nbsp;Meetings&nbsp; &nbsp; &nbsp; 8C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/01/2022&nbsp; &nbsp; &nbsp; &nbsp;Meetings&nbsp; &nbsp; &nbsp; 8A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/03/2022&nbsp; &nbsp; &nbsp; &nbsp;Meetings&nbsp; &nbsp; &nbsp; 8C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/02/2022&nbsp; &nbsp; &nbsp; &nbsp;Meetings&nbsp; &nbsp; &nbsp; 8&nbsp;The above table is very simplified, we have hundreds of employees with varous types of line tasks they can choose from, but the above table is a consice enough example.&nbsp;Now for this example say if our reporting period was between 10/01/2022 - 10/03/2022.We can deduce that employee A has submitted time for all 3 days. Employee B has days 10/02 &amp; 10/03 missing and employee Cis missing 10/03.&nbsp;&nbsp;I also have a tables with all employee names that looks like:&nbsp;name totalhoursA&nbsp; &nbsp; &nbsp; &nbsp; 24B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16&nbsp;This above table was easy to calculte using dax.&nbsp;&nbsp;My goal is to report this in some sort of manner but I am having difficulties calculting those missing days in Power Bi.First I though i should make a calendar table in dax and have each employee as a column something that looks like this:Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C10/01/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;True&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;True&nbsp; &nbsp; &nbsp;&nbsp;True10/02/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; True&nbsp; &nbsp; &nbsp; False&nbsp; &nbsp; &nbsp; True&nbsp;10/03/2022&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;True&nbsp; &nbsp; &nbsp; False&nbsp; &nbsp; &nbsp; &nbsp; FalseThe trues represent that the timesheet entry is present, and false represents that they are missing.I can create a table with the dates in both dax and power query editor, but I have no idea how to make each employee as a column and do the caluclation if the sheet is missing or not.&nbsp;Maybe Im approaching this problem in a wrong way altogether? Im thinking like an excel user trying to make the above table, but I donot know how I could use measures to do what i want to achieve. Thank you

chrismendoza · Accepted Answer

Anonymous&nbsp;- you can do as:
myMeasure = 
IF(
    LOOKUPVALUE(
        TableName[Date],
        'Date'[Date],SELECTEDVALUE(TableName[Date])
    ),
    TRUE()
)

Forum Discussion

Creating A Missing Timesheets Table

2 Replies

Related content

Help With Missing Timesheet Counts

missing data

Count active employees with missing timesheets

missing data

Generating Missing Data