Forum Discussion
cocomy
Resolver I
Resolver IProduce monthly dataset by calculation
Hi All, I have a list of Branch capacity with start and end date. (left) I want to make monthly list by country with total capacity. Is there any way I can make by calculation?(right) ...
Zubair_Muhammad
Community Champion
Community Champion
Generateseries function
"Returns a single column table containing the values of an arithmetic series, that is, a sequence of values in which each differs from the preceding by a constant quantity. The name of the column returned is Value."
Since you needed 16 months (Jan 17 to April 18), I used GenerateSeries(1,16) to generate 16 rows
Then these were Crossjoined to each row of your existing table
cocomyResolver I
Resolver IThank you so much! I could not figure that is the number if months.
All thebes
cocomy
All thebes
cocomy