Add data if data is missing

Hi Anonymous ,

Don't know if the tables are as I have made the setup but try the following:

Tables:

• Employees
• Calendar
• Daily Form Responses
• Rest Day

Relationships:

• Employee 1 -> * Daily Form Responses
• Employee 1 -> * Rest Day
• Calendar 1 -> * Daily Form Responses

Add a column with the weekday on the calendar table and on the Rest day, then make the following measure:

Status_Measure = 
IF (
    MAX ( 'Daily Form Responses'[Status] ) = BLANK ();
    IF (
        SELECTEDVALUE ( 'Calendar'[Weekday] ) = SELECTEDVALUE ( 'Rest Day'[Weekday] );
        "OUT OF OFFICE";
        "NO ENTRY"
    );
    "SUBMITTED"
)

Now just add a condittional formatting formula:

Condittional formating =
SWITCH (
    [Status_Measure];
    "NO ENTRY"; "RED";
    "OUT OF OFFICE"; "YELLOW";
    "GREEN"
)

Result is below and in attach PBIX file.