Time sheet dont have all date

[matus_jun]

Hi im sorry for my english 
my shift_date dont have date when employee dont work and I cant count Consecutive workday 
can I fill shift_date and if that day have no data workday = 0 
please Help me how to it 
thank you alot

[v-tangjie-msft]

Hi @matus_jun ,

Thanks timalbers for the quick reply. I have some other thoughts to add:

(1) My test data and data model are the same as yours.

(2) Create a measure.

Workday = IF(MAX('Table'[shift_date]) in VALUES('CALENDAR'[Date]),1,0) 

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[timalbers]

Hi @matus_jun ,
you may want to create a date table within your model. You could do this with the following DAX code:

calendar_table = CALENDARAUTO()

Afterwards you just need to connect the date column of the newly created date table with your shift_date column in the model view. You can now use the new column for your visual instead of the shift_date column.

This will ensure that you can show every day and not just the days in your fact table.

[matus_jun]

Thank you alot but I got date as blank when i use it with emp_id
did I do something wrong?

[timalbers]

This happens often when there is no proper relationship between the fields. 

It's hard to tell exactly, as I don't know how your model is set up.

Could you share a screenshot of your model view?

[matus_jun]

this is my model view

[timalbers]

Try to set up a filter in the filter pane after selecting your visual.

Something like this: "Date" is not blank

[matus_jun]

Im sorry but I still got blank value

[timalbers]

I'm sorry to hear that, but I fear I am not able to help you without taking a deeper look inside your model. Is it possible for you to share a example pbix file? Remeber to remove all sensitive information you don't want to share.

[matus_jun]

How can I send it to you?

[timalbers]

You may upload your file to a cloud storage (like OneDrive, Dropbox, Google Drive or Wetransfer for example) and paste the link to that storage location.