Forum Discussion
Logistics Forecast Distribution
Hi everyone! Im trying to forcasting how our trucks are going to be busy in the next day. The information that I have is the shipping plant (have many), the order and the stimating time of start ti...
Let's assume you have index numbers in a column called [IDX] from 1 to n. Your DAX would be something like
Val = 1+MOD([IDX]-1,6)
Im expecting to get another column with the numer I set in the what if parameter, get to that number and repeat based on the start time... i mean if I set de number 6, i would get the next information:
1
2
3
4
5
6
1
2
3
4
5
6
1
...
Let's assume you have index numbers in a column called [IDX] from 1 to n. Your DAX would be something like
Val = 1+MOD([IDX]-1,6)
Yes, I add an index measure and then another with the info you gave me and it works. Thanks!