Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Creating A Missing Timesheets Table

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.    The primary data table looks something like thi...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    3 years ago

    Anonymous - you can do as:

    myMeasure = 
IF(
    LOOKUPVALUE(
        TableName[Date],
        'Date'[Date],SELECTEDVALUE(TableName[Date])
    ),
    TRUE()
)

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Chris so I used your soultion and it works great, however I wanted to refine this further. In order for the data to be useful I wanted to group the days by week. However for each week, the measure evalutes to false even if all days were true. See the below picture please

Thank You for the help.