Forum Discussion
Combine Start date and End date to make Date range
Hello,
I am trying to create a column that combines the start date and end date of training into one column. Example: is the start date is 10/05/2022 and the end date is 10/08/2022 the date range would be 10/05/2022 - 10/08/2022 that I want in the same row as the data.
1 Reply
- ImkeF
Community Champion
Hi KB26 ,
I've created a function for that a while ago, maybe that's useful for you: Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query – The BIccountant
The plain version for your request would be:
{ Number.From([StartDate]) .. Number.From([EndDate]) }
This creates a list of numbers representing your start- and end-dates with everything in between. You could then expand it and convert back to dates.
