How to add NA to table visual

Hi RKK ,

I worked on a similar report setup recently. We had a User table (containing all user data) and a DailyTimesheet table that captured daily timesheet entries. If a user didn’t submit a timesheet for a particular day, no entry existed, similar to your case.

Initially, we used measures to mark missing entries as “Entry Missing,” but this approach complicated calculations and analysis.

Instead, we did the following:

1. Created a MasterTimesheet table by performing a cross join between the Date (last 3 months) and User ID to generate entries for each user for each day.
2. Linked MasterTimesheet and DailyTimesheet tables on Week Date and User ID via a left join (or relationship) to pull timesheet data into MasterTimesheet. Submitted days populated data, while unsubmitted days had nulls (replaced with “N/A”).
3. Linked MasterTimesheet with the User table to include user information for reporting.

This approach provided a complete view of timesheet data, including missing entries, making it easier to analyze. I recommend a similar setup in your case.

Let me know if you need further help! 😊