Forum Discussion
[HELP] Breaking Inicial Date and Final Date into various date lines in Table Model
Hi danilindoso,
Create a new custom column and try this:
List.Dates([Initial Date],[Final Date]-[Initial Date]+1,#duration(0,0,0,1)).
expand the column.
Please let me know if this resolved the question.Appreciate a thumbs if this is helpful.
Memorable MemberHi danilindoso,
Create a new custom column and try this:
List.Dates([Initial Date],[Final Date]-[Initial Date]+1,#duration(0,0,0,1)).
expand the column.
Please let me know if this resolved the question.
Appreciate a thumbs if this is helpful.
It didn't work :(, it says something about the operation "+" and the #duration is not valid.
Can I attached a File so you can take a look at it?
As a result, I need to check per day, how many campaing products were sold. But it has to consider only the between initial date and final date from each product.
