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()
)

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Anonymous - you can do as:

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