Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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?
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.