Problem with dates

[Anonymous]

Hello!

I try make a hours control panel, but have a problem.

When i try a add weekends, i get one value anything, but i can one value from dates for each person.

I use down fill in this table

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

You can create a date table join with your date without timestamp 

You can have week start and weekend column and use those in the visual

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Appreciate your Kudos.

[Anonymous]

Good morning, @amitchandak.
Actually, this project is about control hours with clock point. This clock point make a line with date of people going work, but he not make a line about days of people dont go to work (missed work).
I try a create this table from complete calendar, code of turn and day of week (turn time is variant about day week).
But when make with down fill, have anything one date from reference for all workers.

Thanks!