Forum Discussion

xxenoss's avatar
xxenoss
Helper I
8 years ago
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...
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi xxenoss

trip durations for every date start point and destiantion is detemined by the next return train's schedule, right?

But I can't find the information about the next return train's schedule for each destiantion to start point from your example.

 

Best regards

Maggie 

xxenoss's avatar
xxenoss
Helper I
8 years ago

Hi Maggie,

 

The return date, as I mentioned, is the same with the departure date, for example train starts 1st of May From Place_A to Destination_A in 10:00 in the morning and returns from Destination _A to Place_A at 6:00 in the evening of the same day.