Forum Discussion
Logistics Forecast Distribution
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)
you can use table variables in your measure but the final result of the measure must be a scalar value (a table with a single row and a single column).
What should the measure compute?
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!