Forum Discussion
Solved
All possible date combinations
Hi, I'm trying to solve the trip duratiopn problem My data looks like this. The first column is the date the train travels to certain destination and returns back the same day. I need to find all p...
Hi xxenoss
Try this measure
Measure = SWITCH ( TRUE (), [max duration] = 1, 1, [max duration] = 2, "1,2", [max duration] = 3, "1,2,3", [max duration] = 4, "1,2,3,4", [max duration] = 5, "1,2,3,4,5", [max duration] = 6, "1,2,3,4,5,6", [max duration] = 7, "1,2,3,4,5,6,7", [max duration] = 8, "1,2,3,4,5,6,7,8", [max duration] = 9, "1,2,3,4,5,6,7,8,9", [max duration] = 10, "1,2,3,4,5,6,7,8,9,10" )Best Regards
Maggie
Hi Maggie,
thank you very much for the answer, it was very helpful. But the thing is that I need to store all possible duration from 1 day up to 10. Not sure if it they can be stored in one cell, separated by coma, or in different cells in the sae row.
Hi xxenoss
Try this measure
Measure =
SWITCH (
TRUE (),
[max duration] = 1, 1,
[max duration] = 2, "1,2",
[max duration] = 3, "1,2,3",
[max duration] = 4, "1,2,3,4",
[max duration] = 5, "1,2,3,4,5",
[max duration] = 6, "1,2,3,4,5,6",
[max duration] = 7, "1,2,3,4,5,6,7",
[max duration] = 8, "1,2,3,4,5,6,7,8",
[max duration] = 9, "1,2,3,4,5,6,7,8,9",
[max duration] = 10, "1,2,3,4,5,6,7,8,9,10"
)
Best Regards
Maggie
Thank you Maggie, this is brilliant,