It is Confusing. You don't have any Missing Dates for Mike. If you want to find for January Month, Create another Excel File for Full January Month Dates, Left Join it with your data and use it to get Missing Dates. Tableau Can generate Dates, but it will be cumbersome, so follow above technique.
I did that and got the result but i only want missing dates till Today
So Suppose Today is 21st Jan and we have Employee Date till 19th Jan
so the output would be
Did not find any help from this
1 of 1 people found this helpful
OK. Would something like this help? All the Xs show the dates which are missing for the employees.
If yes, check out the data file I have attached and the workbook too. Let me know if you don't understand something.