topic Re: Time sheet dont have all date in DAX Commands and Tips

Time sheet dont have all date

matus_jun — Wed, 15 Jan 2025 09:35:51 GMT

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

Re: Time sheet dont have all date

timalbers — Wed, 15 Jan 2025 09:46:39 GMT

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.

Re: Time sheet dont have all date

matus_jun — Wed, 15 Jan 2025 10:25:52 GMT

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

Re: Time sheet dont have all date

timalbers — Wed, 15 Jan 2025 10:56:22 GMT

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?

Re: Time sheet dont have all date

matus_jun — Wed, 15 Jan 2025 11:00:37 GMT

this is my model view

Re: Time sheet dont have all date

timalbers — Wed, 15 Jan 2025 11:02:33 GMT

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

Something like this: "Date" is not blank

Re: Time sheet dont have all date

matus_jun — Wed, 15 Jan 2025 11:05:02 GMT

Im sorry but I still got blank value

Re: Time sheet dont have all date

timalbers — Wed, 15 Jan 2025 11:12:03 GMT

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.

Re: Time sheet dont have all date

matus_jun — Thu, 16 Jan 2025 02:28:39 GMT

How can I send it to you?

Re: Time sheet dont have all date

timalbers — Thu, 16 Jan 2025 11:00:01 GMT

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.

Re: Time sheet dont have all date

Anonymous — Mon, 20 Jan 2025 06:12:31 GMT

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.