cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tirnovar Frequent Visitor
Frequent Visitor

Creating date column from dates between two columns - Query

Hey i am trying to connect calculated time table and data from this data set. (down) But to correct reporting i need to create list of days between start and end in one column with all other columns in same state as they are now.

001.png

My idea is to do it with custom function. Maybe with loop cykle but i really dont know how. Can someone please help me with this?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft artemus
Microsoft

Re: Creating date column from dates between two columns - Query

You can add a custom column with:

List.Dates([start_date], Duration.Days([end_date] - [start_date]) + 1, #duration(1, 0, 0, 0))

Then, expand the custom column.

View solution in original post

1 REPLY 1
Microsoft artemus
Microsoft

Re: Creating date column from dates between two columns - Query

You can add a custom column with:

List.Dates([start_date], Duration.Days([end_date] - [start_date]) + 1, #duration(1, 0, 0, 0))

Then, expand the custom column.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors