Forum Discussion
Anonymous
3 years agoNot applicable
Calculate time per day based between two dates
Hi All, I am a bit stuck in my process. I got a data set what shows me a start date & end date and the expected hours that I would spend on a taks. Now I want to know how much time I would ...
amitchandak
3 years agoSuper User
Anonymous , If want show split across days
refer
Between Dates - Dates between
Tables
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
Measure way
In case you just need diff
new column= datediff([Start Day], [End Date], day)
If this does not help
Can you share sample output in table format?