Forum Discussion

xxenoss's avatar
xxenoss
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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
    Icon for Helper I rankHelper 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.