Forum Discussion

fsim's avatar
fsim
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

start date - end date and sum per month

Hi ! I'm not even sure how to express myself on this problem. I have one table of tasks, with a start date, an end date, a number of allocated daily hours and an user. I also have a calendar table...
Need Help
  • fsim's avatar
    fsim
    4 years ago

    Hi Liang,
    thanks for your answer.

    Obvioulsy, Dax is not the best tool for this. I decided to go back to PowerQuerry and generate a list of date for each reccord. Then I was able to expand the list in new rows. 
    List.Dates([start_date],Duration.Days([end_date]-[start_date])+1, #duration(1,0,0,0))
    Now I have to deal with repeated dates, but this is another storry

fsim's avatar
fsim
Icon for Responsive Resident rankResponsive Resident
4 years ago

Hi Liang,
thanks for your answer.

Obvioulsy, Dax is not the best tool for this. I decided to go back to PowerQuerry and generate a list of date for each reccord. Then I was able to expand the list in new rows. 
List.Dates([start_date],Duration.Days([end_date]-[start_date])+1, #duration(1,0,0,0))
Now I have to deal with repeated dates, but this is another storry